To avoid performing multiple full restores when you are not sure of the point of restore, you can perform a step restore.
After the database is in a standby state, apply either each differential or transaction log, one at a time, to the database. When you apply the logs one at a time, you can scan the changes committed between each log backup.
Before You Begin
To the CommServe computer, add the bEnableAdvancedRestoreOptionsMSSql additional setting. For instructions on adding additional settings from the CommCell Console, see Add or Modify an Additional Setting.
Procedure
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click the instance, and then click All Tasks > Browse and Restore.
-
In the Browse and Restore Options dialog box, click Advanced Restore, then click View Content.
-
Select the data that you want to restore, and click Recover All Selected.
The SQL Restore Options dialog box is displayed.
-
On the General tab, select an SQL server from the Destination Instance list.
Verify that the selected destination instance is not the same as the source instance.
-
To restore the database in a standby state, select Stand By.
-
Click Advanced.
The Advanced Restore Options dialog box is displayed.
-
On the Options tab, select Step Restore, and then click OK.
-
To restore the database to the same location from which it was backed up, on the General tab select the Unconditionally overwrite existing database or files check box.
The existing database files are overwritten.
-
Click OK.