Generating a Database Load Sequence for a Target Database from Dump History

SAP Control Center lets you generate a load sequence from the dump history file.

  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. On the Introduction screen, select Generate load sequence only to generate database load sequence SQL from a specified time. You can save the load SQL for future use. The load sequence consists of a batch of load SQL, such as:
    load database testdb from...
    load transaction testdb from...

    You may restore the database directly from the saved SQL script, either using isql or by using script functionality in ASEMAP.

  5. On the Point in Time screen, select a dump time from the list of points in time in which the database was backed up. By default, the point in time is set to the last database dump time.
  6. On the Options screen:
    • If you used a password during the backup process, you must enter the same password to restore the database.
    • (Optional) Select Restore to target database to generate database creation SQL for a target database that is different from the database you backed up. This target database can reside on a different server.

      If you choose this option, enter the name of the target database.

  7. (Optional) Click Summary to view 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. (Optional) Click Save in the SQL Preview window to save the script to your local machine.