Restoring DB when I only got the MDF & LDF files

  • 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!!

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


  • 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.


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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply