Restoring SQL Databases Out of Place (Moving Databases)

You can move a database to a new location by first renaming the database and the path of the database, and then restoring them to a new location.

Restriction: You cannot move a system database to a different location.

Before You Begin

Before restoring a publication database, verify that the replication settings on the publication database match the settings for the master and msdb databases on the distributor server and the subscriber server.

Procedure

1. From the CommCell Browser, click Client Computers > client > SQL Server.

2. Right-click the instance and then click All Tasks > Browse and Restore.

3. In the Browse and Restore Options dialog box, click Advanced Restore, then click View Content.

4. Select the data that you want to restore, and click Recover All Selected.

   The SQL Restore Options dialog box is displayed.

5. Optional: To restore a database to a different instance, from the Destination Client list, select a SQL server.

   Verify that the restored database resides on the selected destination server and the instance is in a standby state.

6. In the Physical Path column, change the path of the database.

7. Optional: Retain the replication settings of the database in the restored copy. Click Advanced, then in the Advanced Restore Options dialog select the Options tab and select the Preserve Replication Settings check box.

8. Click OK.