Post reply

Restoring to two databases using one backup set

  • July 18, 2009 at 3:29 am

    #155983

    Is it possible to restore to two databases using only one backup set, at the same time?

  • July 18, 2009 at 5:04 am

    #1026528

    not in the exact same operation, but you can use one backup to restore/create as many databases(each with a new name) that you want.

    whether from the GUI, or via script, the steps are the same, you just change the name of the database to be restored...ie Database1, then Database2,Database3 etc.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 18, 2009 at 5:55 am

    #1026532

    you can copy your backup file with a different name(am not sure if same file will work) and then fire the restore command as suggested by Lowell in two different windows(almost at the same time).


    Pradeep Singh

  • July 18, 2009 at 10:05 am

    #1026572

    You can even use the "START" command in a command prompt to spawn a process, or you could use DTS and execute the restores in parallel.

    You do need two different copies of the file.

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

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