• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

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?


1 Solution
Its fine.  SQL doesn't care what extension you give the file names.  You don't have to rename it, unless you want to.
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!!!!
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now