Datafile with .ldf extenstion

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
LVL 18
sventhanAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
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
 
sventhanAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.