Please enter search query.
Search <product_name> all support & community content...
How to redirect restore a SQL database to the same or a different server or instance, renaming the database to avoid overwriting the original
Article: 100008645
Last Published: 2013-09-23
Ratings: 1 4
Product(s): Backup Exec
Problem
Need to restore a SQL database without overwriting it.
Solution
- Create a new Restore Job, Select Microsoft SQL Server databases and click Next.
- Select the database to be restored with a new name and click Next.
- Select “To the latest available backup set time” and click Next.
- Select “Redirect the data to a different SQL Server instance and/or database name”. Enter target SQL server instance details and click Next.
- Enter the name for the new database to be created and click Next.
- Do not select any option and click Next.
- Select the consistency check to perform on the process and click Next.
- If no additional tasks are required, leave the defaults and click Next.
- Type in a name to identify this job and click Next.
- Verify the job settings in the Summary and click Finish.
- Once the job has been completed, to verify that the database was properly restored, click in One-Time Backup as if a new backup job was to be created and find the new database in the selection list entry for the SQL instance where the restore took place.