May 16, 2005 at 4:35 pm
I have a database I'd like to test (from an outside source). I need to restore from backup to a live DB. When in EM trying to do that, the list of database backups to select from does not include the new DB I want to load. How do I get this live from a .bak file?
Thanks for your patience.
Sam
May 16, 2005 at 5:12 pm
Choose restore "From device", then next (pick disk) you should have some screen where there's a "browse" sort of option to select a file path on your computer...
May 17, 2005 at 7:40 am
1. From the restore screen select the database you are going to restore if you are restoring over an existing database, if the database is new to the instance enter the database name you wish to restore (the db name does not need to be the same as when the backup was taken).
2. Choose 'From Device'
3. Select Devices and drill to and select the backup file.
4. Select OK back to the Restore screen.
5. Select the options tab
6. If you are restoring over an existing database choose 'Force Restore'
7. Check the physical name and change the db name and path as required.
8. Choose recovery state depending on what you would like for a db status when you are done.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply