April 24, 2006 at 9:03 am
where do you reference the backup file in in enterprise manager when restoring a database to a new server?
April 24, 2006 at 10:04 am
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
April 24, 2006 at 10:06 am
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
April 24, 2006 at 10:28 am
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