DB File Extension

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tariq » DB File Extension

32 posts, Page 1 of 4

1 2 3 4 »»»

DB File Extension

Rate Topic

Display Mode

Topic Options

Author

Message

Muhammad Tariq

Posted Wednesday, August 27, 2008 9:00 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 5:32 AM
Points: 138, Visits: 234

Comments posted to this topic are about the item DB File Extension

Tariq
master your setup, master yourself.
http://mssqlsolutions.blogspot.com

Post #560093

Ben Leighton

Posted Thursday, August 28, 2008 12:53 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 8:18 AM
Points: 582, Visits: 359

why oh why did I think this was a trick question?:)
Of course .ldf is a sql server file extension... but is .ldf really a "sql server database" file extension. My reasoning? For a fully functioning sql server database you need all the .mdf and .ndf files that were set up when the database was created... the .ldf is merely a list of recent transactions. Lose either the .mdf and .ndf files and you will have nothing that will work... delete the .ldf and you simply lose a few transactions.
One valuable point missed I think!

Post #560162

timothyawiseman

Posted Thursday, August 28, 2008 1:31 AM

Right there with Babe

Group: General Forum Members
Last Login: Monday, June 17, 2013 12:40 PM
Points: 748, Visits: 905

I'm inclined to agree with Ben. It does depend on how you define the terms, but I generally do not think of ldf as a database file.

It stores log information, and while that can be valuable it does not store relational database information per se. You can destroy and recreate the ldf file with very minimal consequences, but if an mdf or ndf file is damaged you will be looking for the backups.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/

Post #560187

rodjkidd

Posted Thursday, August 28, 2008 2:43 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:59 AM
Points: 2,498, Visits: 3,702

Actually they are all listed in BOL together as files, so i would agree with the Question. Helps I got it right as well ;)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39e00ebe-c9b7-4d53-90bd-15de2015fd34.htm

Not sure if that works for everyone, as I find it weird that my local BOL gives a web type address for the pages... So no idea if that's universal for all installs.

Actually I was in two minds about .ndf - I knew it was a suggested extension for secondary data files but wasn't sure if it was the default. Picked it anyway, so for once I got a fifty fifty right! I get a very high number of fifty fifty's wrong - which statistically speaking shouldn't the be the case :)

Post #560218

Wilfred van Dijk

Posted Thursday, August 28, 2008 3:27 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898, Visits: 1,049

aaaargh! .ldf is not a databasefile extension, but a logfile extension. Crazy

So i disagree with the suggested "correct" answer

Wilfred
The best things in life are the simple things

Post #560234

rajankjohn

Posted Thursday, August 28, 2008 3:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 2:53 PM
Points: 1,199, Visits: 568

another confusing QOD

Post #560241

elbedata

Posted Thursday, August 28, 2008 3:46 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:59 AM
Points: 3,718, Visits: 974

He, He, Didn't think about *.ldf as a "database" extension.
Sometimes the QOD wording could be better... :P

Lars Broberg
Elbe-Data AB

Post #560254

Mighty

Posted Thursday, August 28, 2008 4:13 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 2,747, Visits: 991

Please don't confuse "database files" with "data files".
A database is more than just a data file.

Post #560266

skyline666

Posted Thursday, August 28, 2008 4:28 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229

Michael Kipp (8/28/2008)

Please don't confuse "database files" with "data files".
A database is more than just a data file.

According to the link provided with the QOD, .mdf, .ndf and .ldf all come under "database files", and it states .mdf and .ndf as "data files".

Post #560276

Jamie Longstreet-481950

Posted Thursday, August 28, 2008 6:27 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:25 PM
Points: 2,472, Visits: 720

Gee... I figured I would get this one wrong. It was so obvious that the question was not specifically including log files when the statement asked for database files, that the question was not, what are the extensions, but was the person writing the question going to be grouping log files with database files? Now I can see that the person is actually Microsoft and they call them database files. I call them log files. Same thing. So the question is now - is Microsoft right or me?

OK, Microsoft, I concede - you're bigger than I am.

Jamie

Post #560334

« Prev Topic | Next Topic »

32 posts, Page 1 of 4

1 2 3 4 »»»

Permissions