You can restore one or more databases to a different SQL instance or move them to a new location by first renaming the databases and the paths of the databases, and then restoring them to a new location. The data being restored is unconditionally written and overwrites the files of any other databases that are currently using the same database names or path. The time you specify in the Time tab is used and all connections to the databases are dropped to ensure exclusive access for the restore operation.
Procedure
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click the instance and then click All Tasks > Browse and Restore.
-
In the Browse and Restore Options dialog box, select Restore out of place, then click View Content.
-
In the browse view, select the data that you want to restore, then click Recover All Selected.
The SQL Restore Options dialog box is displayed.
-
Optional: To restore a database to a different destination instance, from the Destination Client list, select the destination client. From the Destination Instance list, select the SQL server instance.
-
In the Database column, change the database name.
-
In the Physical Path column, change the path of the database.
-
Click OK. The restore job runs immediately.