If any unwanted transactions occur in the database, you can restore the database to a point in time just before the transaction occurred. If there is a database failure, you can restore the database to a time just before the failure. The database is restored to the same location from where it was backed up causing the existing database files to be overwritten.
-
To synchronize all databases, you can restore multiple databases to a particular time.
-
Backing up the tail of the log is critical if you want to restore to a time just before the point of failure. For more information, see Tail Log Backup.
Note
After performing a point-in-time restore on a database, the next scheduled backup on the database is converted to a full backup operation.
Before You Begin
Verify that the transaction logs for the database are backed up.
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 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 database to the same location from which it was backed up, select the Unconditionally overwrite existing database or files check box.
The existing database files are overwritten.
-
Click OK.