Post reply

Restoring DB when I only got the MDF & LDF files

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

  • 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
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • 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

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

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