Restoring DB when I only got the MDF & LDF files

• msalmon

  Grasshopper

  Points: 12

  More actions

  September 28, 2001 at 10:39 am

  #104682

  I've a Database(SQL7) that got missed during the Backup routine. As a result I've only got the actuall MDF & LDF files. How can I restore these files to the Create the original Database? Help!!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 28, 2001 at 10:54 am

  #418574

  Just reattach. In SQL2K right click databases, select attach, browse to find the files. In SQL 7 use sp_attach. See BOL for details.

  Andy

  Andy
  Connect with me on LinkedIn

• msalmon

  Grasshopper

  Points: 12

  More actions

  October 1, 2001 at 4:52 am

  #418585

  Thanks Andy - I had to 'drop database' prior to using the 'sp_attach_db' command, so as to remove the pointer from the 'master.db'

  Thanks again for the amazingly fast response.

  Mark.

  Edited by - msalmon on 10/01/2001 04:55:02 AM