Recovering a SQL Server Database in the Offline State

You can recover the SQL server database in the offline state.

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 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.

   The SQL Restore Options dialog box appears.

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

   The existing database files are overwritten.

7. Select No recovery.

8. Click OK.