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

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

mrotor
mainrotorAsked:
Who is Participating?
 
Leo TorresSQL DeveloperCommented:
No its Ldf. Its just that the L is lower case .ldf
0
 
Lee SavidgeCommented:
LDF  file is the SQL Log file. And yes, it exists. In all versions of SQL Server, there is an LDF file.
0
 
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??
0
 
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?
0
 
mainrotorAuthor Commented:
Thank you very much!  You have all been very helpful!

mrotor
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.