Referencing backup file in enterprise manager

  • where do you reference the backup file in in enterprise manager when restoring a database to a new server?

  • All Tasks -> Restore Database -> General Tab -> Choose 'From Device' radio button -> Click Select Device button -> Add -> and choose your file.

    You will provably need to click the options tab as well to move the logical names to a new path unless old server vs new server directory structures are identical.

    Allen

     

     

     

     

     

  • Right-click on Database since you're creating the database with the restore.  Select Restore from device and click on the 'Select Devices...' button.  Then you can add you backup files to the list of files to restore.

    Greg

     

    Greg

  • works - thank you both

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

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