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.

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 you want to back up.
4. Click the arrow and select Restore to start the Restore Database wizard.
5. In the wizard's Introduction screen, choose Default.
6. In the Type of Restore screen, choose Cumulative restore.
7. 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.

8. (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.

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