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

What is the full form of mdf, ldf and ndf ??? Expand / Collapse
Author
Message
Posted Wednesday, October 3, 2012 2:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 3:47 AM
Points: 23, Visits: 60
Post #1367470
Posted Wednesday, October 3, 2012 3:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 5,131, Visits: 4,918
What is the question?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1367476
Posted Wednesday, October 3, 2012 3:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
Primary data file, secondary data file for mdf and ndf if it's important. Ldf is the log file, no D, probably just there to keep the pattern


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1367485
Posted Wednesday, October 3, 2012 4:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 57, Visits: 188
MDF and LDF: Master Data File and Log Data File
NDF: I dont think this has a full form but since it is secondary master data file, MS would have named it "N"DF since "N" follows "M" :)
Post #1367531
Posted Monday, October 22, 2012 4:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 20, 2014 4:20 AM
Points: 253, Visits: 78
I like to think of it as:

master data file
named data file
log data file

Just like any instance added besides the default would be called a named instance. So why not for the data files?
Post #1375335
Posted Monday, October 22, 2012 11:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128
SQL Server databases have three types of files:

Primary data files
The primary data file is the starting point of the database and points to the other files in the database. Every database has one primary data file. The recommended file name extension for primary data files is .mdf.

Secondary data files
Secondary data files comprise all of the data files other than the primary data file. Some databases may not have any secondary data files, while others have multiple secondary data files. The recommended file name extension for secondary data files is .ndf.

Log files
Log files hold all of the log information used to recover the database. There must be at least one log file for each database, although there can be more than one. The recommended file name extension for log files is .ldf.

SQL Server does not enforce the .mdf, .ndf, and .ldf file name extensions, but these extensions are recommended to help identify the use of the file.

Thanks

Peter
Post #1375840
Posted Wednesday, October 24, 2012 10:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 6, 2014 4:12 AM
Points: 3, Visits: 12



When we create a db,the create command will create a data
file with an Extension .mdf,as well as a transaction log
file with extension .ldf

Any additional or secondary data files have .ndf extension

.mdf is extention of primary file,
.ndf is extention of secondary file,
.ldf is extention of log file,

Krishna
Post #1376766
Posted Sunday, December 8, 2013 6:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 12:04 AM
Points: 4, Visits: 584
mdf - master data file
ldf - log data file

and NDF -- NOT master data file

According to one anecdote, when discussing the extension for the secondary data files, one of the developers suggested, humorously, using .ndf to represent “Not Master Data File,” and the idea was accepted.
Post #1520863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse