SQL Server Performance

MDF & LDF

Discussion in 'General DBA Questions' started by Jeyanthan, Jan 22, 2006.

  1. Jeyanthan New Member

    Hi,

    What is the full form of .mdf & .ldf,

    also i take full backup

    if i wanted to attach the data base is it possible to do attaching instead of restoring the database?


    Rgds

    Jey
  2. ghemant Moderator

    Hi,<br />sure you can attach / deattach database , refer sp_attach_db ,sp_detach_db and search <br />* How to attach and detach a database (Enterprise Manager) * in BOL for more .<br /><br />MDF = Master Data File<br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  3. satya Moderator

    YOu can attach the database if you have detached the database properly, so refer thru the books online as per the suggestion above.

    Both will work in same way, but BACKUP/RESTORE is managable than DETACH/ATTACH.

Share This Page