Restoring Sybase Databases to a Point-in-Time

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

1. From the CommCell Browser, expand Client Computers > client > Sybase.

2. Right-click the instance, point to All Tasks and then click Browse and Restore.

3. On the Browse and Restore dialog box, click View Content.

4. 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.

5. On the General tab:

   1. Select the Point-in-time check box.

   2. In the Restore Time box, enter the date and time.

   3. When the client is in a different time zone that the CommServe computer, select the client time zone from the Time Zone list.

6. 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.