Post reply

mdf,ldf

  • May 14, 2009 at 11:06 pm

    #209319

    i am new sqlserver breif explain what data going to mdf,ldf files in the database.

    Thanks,

    Sathish.

  • May 14, 2009 at 11:51 pm

    #995087

    mssqlsvr (5/14/2009)

    i am new sqlserver breif explain what data going to mdf,ldf files in the database.

    Thanks,

    Sathish.

    Please don't cross post.

    Direct replies to: http://qa.sqlservercentral.com/Forums/Topic713653-357-1.aspx

  • May 15, 2009 at 12:00 am

    #995092

    MDF are the primary data file in a File Group. These files contain "data" - so your tables, indexes, keys, constraints, UDF, UDT, stored procs, functions, etc...

    LDF files are your transactions.

    NDF files are the same as MDF except they are subsequent datafiles in a File Group

    BAK files are your full backups

    TRN files are your transaction backups

    --
    Andrew Hatfield

Viewing 3 posts - 1 through 2 (of 2 total)

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