Restoring a Database from a Point in Time

Restore a database backup from a specific point in time.

You cannot load a database backup that was created on a different operating system, or with an earlier version of SAP ASE.

  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. Click the Name field of the database, then click the drop-down arrow and select Restore.
  4. In the wizard's Introduction screen, choose Restore point-in-time.
  5. 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.
  6. (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.

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