If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction. The point in time option enables you to restore the database to a specific point-in-time. This option is useful in the following scenarios:
-
If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction.
-
If a database fails, you can restore to the state just before the point of failure.
-
You can restore multiple databases to a consistent time. This will be useful for the absolute synchronization of the databases.
Before You Begin
-
Ensure that transaction logs for the database are backed up.
-
Verify that the time zone for the Sybase operating system user profile and the root user profile on the client is the same.
Procedure
-
From the CommCell Browser, expand Client Computers > client > Sybase.
-
Right-click the instance, point to All Tasks and then click Browse and Restore.
-
On the Browse and Restore dialog box, click View Content.
-
From the Browse window, select the databases that you want to restore in the right pane and click Recover All Selected.
The Restore Options dialog box is displayed.
-
On the General tab:
-
Select the Point-in-time check box.
-
In the Restore Time box, enter the date and time.
-
When the client is in a different time zone that the CommServe computer, select the client time zone from the Time Zone list.
-
-
Click OK to start the restore.
Result
The databases are restored to the selected data and the next scheduled backup for that database automatically converts to a full backup.