Restoring SQL Transaction Logs to a Hot Standby Server

You can restore the latest copy of the transaction logs to a standby server. If the database on your production server fails, you can apply the latest log backup to the standby server and bring it online.

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 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. On the General tab, from the Destination Server list, select the server where the latest copy of the transaction logs resides.

6. Click Advanced.

   The Advanced Restore Options dialog box is displayed.

7. On the Options tab, select the Latest Backup Data check box and the Apply Log Backups Only check box, and then click OK.

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

   The existing database files are overwritten.

9. Click OK.