is there such a thing as an idf file in SQL Server 2008 R2

is there such a thing as an idf file in SQL Server 2008 R2?

Who is Participating?
Leo TorresSQL DeveloperCommented:
No its Ldf. Its just that the L is lower case .ldf
Lee SavidgeCommented:
LDF  file is the SQL Log file. And yes, it exists. In all versions of SQL Server, there is an LDF file.
Scott PletcherSenior DBACommented:
There could be.  SQL doesn't actually care what extension you use for a file name; you can even leave off the extension if you want to.

So it's certainly possible someone mistyped the name and used ".idf" rather than ".[l/m/n]df".

Btw, fwiw, I use ".mdf" for all my files.  At the physical file level, do I really care that a data file is secondary not primary??
ste5anSenior DeveloperCommented:
hmm, well not per se. But you can name database files as you want.

From the name, it's an index file? What database?
mainrotorAuthor Commented:
Thank you very much!  You have all been very helpful!

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.