Restoring (Loading) a Database

Restore a database backup and its transaction log.

Decide to load the backup into a new database with the for load option, or into a preexisting database.

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

Note: When loading an archive database, the block size and compression level are set to the system default value for each stripe.
  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
  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:
    • Default – loads a database or its transaction log from a single or multiple dump devices.
    • Restore using script – loads a database from an existing SQL script.
    • Restore point-in-time – loads a database from a specified time in the database dump sequence.
    • Generate load sequence only – generates 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 Execute SQL or script functionality in ASEMAP or by using ISQL.

  5. In the Type of Restore screen, choose to restore the entire database or only the transaction log. This option is available only when you select the Default restore option.
  6. By default, the Dump Device screen is initially empty. Click Add to identify the dump devices or dump stripes you want to load back into the database:
    • Named dump device – select the device from the menu.
    • Explicit dump device – specify a local dump device as either an absolute path name or relative path name. When dumping across the network, specify an absolute path name.

      You can specify the backup server as your remote dump device when using a default server. This option is not available when loading an archive database; use Named dump device instead.

      If you select a remote backup server, select its server name from the drop-down list.

  7. (Optional) In the Options screen, if you specified a password for backup, you must use the same password while restoring the database.

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

  8. (Optional) Click Summary to view 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. SAP Control Center displays restore messages from the server.
Related tasks
Backing Up (Dumping) a Database