Restoring a Database from a Cumulative Dump

Restore a database backup and its transaction log from a cumulative backup, in which only the changes since the last full database dump are backed up.

Decide whether 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.

  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 Default.
  5. In the Type of Restore screen, choose Cumulative restore.
  6. In the Dump Devices screen, specify the dump stripes from the list. To add dump devices for the dump operation, click Add:
    • 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 unavailable when you are loading an archive database.

  7. (Optional) In the Options screen, if you used a password during the backup process, enter this password.

    Click 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 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. SAP Control Center displays restore messages from the server.