Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

DB File Extension Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2008 9:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 2:10 AM
Points: 138, Visits: 236
Comments posted to this topic are about the item DB File Extension

Tariq
master your setup, master yourself.
http://mssqlsolutions.blogspot.com
Post #560093
Posted Thursday, August 28, 2008 12:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 5, 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
Posted Thursday, August 28, 2008 1:31 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
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
Posted Thursday, August 28, 2008 2:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:27 PM
Points: 2,951, Visits: 5,236
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
Posted Thursday, August 28, 2008 3:27 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:57 AM
Points: 928, Visits: 1,116
aaaargh! .ldf is not a databasefile extension, but a logfile extension.
So i disagree with the suggested "correct" answer


Wilfred
The best things in life are the simple things
Post #560234
Posted Thursday, August 28, 2008 3:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:36 AM
Points: 1,199, Visits: 574
another confusing QOD
Post #560241
Posted Thursday, August 28, 2008 3:46 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, July 13, 2014 8:35 AM
Points: 3,926, Visits: 1,087
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
Posted Thursday, August 28, 2008 4:13 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:33 AM
Points: 3,198, Visits: 1,236
Please don't confuse "database files" with "data files".
A database is more than just a data file.
Post #560266
Posted Thursday, August 28, 2008 4:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Thursday, August 28, 2008 6:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
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 »

Add to briefcase 1234»»»

Permissions Expand / Collapse