mdf,ldf

• mssqlsvr

  SSC Enthusiast

  Points: 109

  More actions

  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.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  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://www.sqlservercentral.com/Forums/Topic713653-357-1.aspx

• Andrew Hatfield

  SSCrazy

  Points: 2241

  More actions

  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