Restoring a Database to the Current State (Step-by-Step Restore)

When you want to restore an event in the database but do not know the exact time of the event, you can first restore the database to the last full backup and then run a Step-by-Step restore to apply the logs by the sequence of log backups. Step-by-Step Restores are performed on individual databases. You will not be able to schedule a step-by-step restore.

You must repeat this procedure until you get to the correct restore time.

Note: This is a controlled restore and applicable for restoring a single database.

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. From the Destination Server list, select the destination server name.

   2. Select the Restore Options check box.

   3. Select Sybase Step By Step option.

   4. Select the last Full backup time from the Restore Time drop down list.

   5. Click No Recover.

6. Click OK to start the restore.