If you use any third-party software to restore the SQL databases, you can use the SQL Server Agent to restore only the logs. The most recent log backup before the selected restore time is restored and applied to the database.
Before You Begin
Verify that the database for which you are restoring the logs is in a standby or a restoring state.
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, from the Destination Instance list, select a SQL server.
Verify that the restored database resides on the selected destination instance and the instance is in a standby state.
-
Select the Point-in-time check box.
-
In the Restore Time list, select the point in time up to which you want to restore the log backup.
The transaction log backed up on the selected restore time will be restored and applied to the database.
-
To restore the logs to the same location from which they were backed up, select the Unconditionally overwrite existing database or files check box.
The existing database files are overwritten.
-
Click Advanced.
The Advanced Restore Options dialog box is displayed.
-
On the Options tab, select the Skip Full Backup check box, and then click OK.
-
Click OK to close the SQL Restore Options dialog box.