Moving a SQL Server Database

You can restore the database to a different location without changing its name. You cannot move a system database to a different location.

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. In the browse view, select the data that you want to restore, and click Recover All Selected.

   The SQL Restore Options dialog box appears.

5. To change the database and log files path, in the Physical Path column, type the full path to the new location.

   Note

   If there are many files, use the Find & Replace option to enter the new destination path for all of them at once.

   If the database file path is changed without changing the database name, the existing database will be overwritten and will point to the new location.

6. Click OK.