Solved

Datafile with .ldf extenstion

Posted on 2011-03-22
2
675 Views
Last Modified: 2012-05-11
Experts -

I made a simple and stupid mistake. I've created a datafile with .ldf extension? How this file being treated in sql server db?

I do not see any issues so far.  Can I just leave it like it or do I've to rename the file to .ndf?

Thanks,

~sve
0
Comment
Question by:sventhan
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 35195254
Its fine.  SQL doesn't care what extension you give the file names.  You don't have to rename it, unless you want to.
0
 
LVL 18

Author Closing Comment

by:sventhan
ID: 35195274
Thanks so much. Its a mirror DB thats the reason I'm little concern.  Its happy to know "its fine" answer from the expert.

Thanks again Chapmandew!!!!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question