.mdf / .bak / .ldf

• athma

  Grasshopper

  Points: 20

  More actions

  January 24, 2011 at 11:23 pm

  #1277622

  .ldf is a log file its not a transaction log backup,it will be created automatically when the database is created.

  .mdf is a primary data file it will b created automatically when the database is created, there is also .ndf its a secondary data file

  .bak is a backup file when u take a backup the backup file will be create with the file extension of .bak

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  January 29, 2011 at 9:18 am

  #1280088

  athma (1/24/2011)

  ---

  .ldf is a log file its not a transaction log backup,it will be created automatically when the database is created.

  .mdf is a primary data file it will b created automatically when the database is created, there is also .ndf its a secondary data file

  .bak is a backup file when u take a backup the backup file will be create with the file extension of .bak

  Welcome aboard and absolutely correct... same as what was said in the second post of this thread but confirmation is good. 😀

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)