Recovering One or More SQL Server Databases in the Online State

If you have a database in the offline or standby state and you want to bring the database back to the 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.

   The SQL Restore Options dialog box appears.

6. Click Advanced.

   The Advanced SQL Restore Options dialog box appears.

7. On the Options tab, select Recover Only, and then click OK.

8. Click OK.