Monday, November 29, 2010

How can I attach .MDF file?

It is recommended that you backup your database every day. Please note that at the time of server crash backup files are the main resources for recovery. However attaching .MDF files are always the second option.

The steps to attach an .MDF file are.

You can use Microsoft SQL Server Management Studio Express attach MDF file.

  1. Start > Programs > Microsoft SQL Server 2005
  2. Open Microsoft SQL Server Management Studio Express
  3. Connect the server
  4. Right click on Database in Object Explorer
  5. Will find a list of options
  6. Click on Attach
  7. Click on Add
  8. Select .Mdf file from browse screen
  9. Click ok on browse screen
  10. Delete log file using remove button
  11. Click Ok and the database should attach.

No comments:

Post a Comment