Restoring a Database from a Point in Time

Restore a database backup from a specific point in time.

1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
2. Select one of:
   • User Databases
   • System Databases
   • Archive Databases
   • In-Memory Databases

   The Restore wizard is unavailable if you choose:

   • Temporary Databases
   • Proxy Databases
   • In-Memory Temporary Databases
3. Right-click the Name field of the database to back up.
4. Click the arrow and select Restore to start the Restore Database wizard.
5. In the wizard's Introduction screen, choose Restore point-in-time.
6. Click Point In Time, and:
   • Select a time range from the list. A time range represents a valid dump sequence that contains a database dump and a set of transaction dumps.
   • Select a range of time in the database dump sequence that spans from the time of the first dump to the time of the most recent dump.
7. (Optional) In the Options screen, if you specified a password for backup, you must use the same password while restoring the database:

   Select On-line database to bring the database online after the restoration is complete. By default, this option is not selected.

8. (Optional) Click Summary to verify your selected options.
9. (Optional) Click Preview to view the SQL statement you generated with your settings. To save a copy of the SQL statement, click Save.
10. Click Finish to start the restore process. Sybase Control Center displays restore messages from the Adaptive Server.