Post reply

What is the full form of mdf, ldf and ndf ???

  • October 3, 2012 at 2:47 am

    #265127

    🙂

  • October 3, 2012 at 3:07 am

    #1544738

    What is the question?

  • October 3, 2012 at 3:21 am

    #1544745

    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, MVP, M.Sc (Comp Sci)
    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

  • October 3, 2012 at 4:18 am

    #1544784

    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" 🙂

  • October 22, 2012 at 4:56 am

    #1551299

    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? :hehe:

  • October 22, 2012 at 11:54 pm

    #1551727

    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

  • October 24, 2012 at 10:37 pm

    #1552502

    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

  • December 8, 2013 at 6:17 am

    #1671753

    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.

  • January 16, 2015 at 2:26 pm

    #1770906

    I'm thinking more along the lines of:

    .mdf = master data file

    .ldf = log data file

    .ndf = "next" data file

    🙂 Crazy I know...

  • January 16, 2015 at 2:49 pm

    #1770910

    Ronnie Jones (1/16/2015)

    I'm thinking more along the lines of:

    .mdf = master data file

    .ldf = log data file

    .ndf = "next" data file

    🙂 Crazy I know...

    ya'll missed the southern naming influece here. i always say it's this:

    .ndf = "nother" data file

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 16, 2015 at 5:12 pm

    #1770923

    Lowell (1/16/2015)

    ya'll missed the southern naming influece here. i always say it's this:

    .ndf = "nother" data file

    +1

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply