Post reply

restoring the database in another instance

  • April 13, 2007 at 2:51 pm

    #118175

    I have a backup of a database say 'abc' and i want to restore the backup in another named instance of the SQL server through query analyzer, how do I do it, can anyone suggest me a simple solution.

  • April 13, 2007 at 3:06 pm

    #700522

    Run RESTORE FILELISTONLY FROM DISK='fully qualified backup path and file name' to get the abc_data and abc_log values for below.  Then restore the DB using a QA session opened up to the desired destination instance.

    RESTORE DATABASE abc

    FROM DISK='fully qualified backup path and file name'

    WITH MOVE 'abc_data' TO 'new data file location',

        MOVE 'abc_log' TO 'new data file location',

        STATS

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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