Restoring a SQL Server Database

By default, a database is restored in the same location from where it was backed up and the existing database files are overwritten. This restore leaves the database in an online state.

Procedure

1. From the CommCell Browser, expand 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 system databases to restore in the right pane and click Recover All Selected.

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

6. To restore the database to the same location from where it was backed up, on the SQL Restore Options dialog box, select the Unconditionally overwrite existing database or files check box.

   The existing database files are overwritten.

7. Click OK.