Backing Up a Database Incrementally Using a Dump Configuration

Using a dump configuration file, perform a cumulative dump, which is a type of incremental dump (backup) in which only changes since the last full database dump are backed up.

Prerequisites

If you do not do this before performing the task, you cannot select the cumulative backup option.

Task
Note: You cannot perform cumulative dumps in a cluster configuration.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • In-Memory Databases
  3. Click the Name field of the database, then click the drop-down arrow and select Back up.
  4. In the Introduction screen of the Backup Database wizard, select Backup using configuration. Select the configuration to use.
  5. In the Type of Backup screen, choose Cumulative backup. This creates a copy of all the changes in the database since the last time the entire database was backed up.

    To verify that you have enough space, click Estimate Dump Size.

  6. (Optional) The selections in the Options screen are disabled unless you click Use modified options. These options are not part of the dump configuration, but are for the dump database and dump transaction commands. This means that some of the options take precedence over the configured parameter value stored in the dump configuration file for a particular dump operation. See dump database and dump transaction in Reference Manual: Commands for more information on these options:
    OptionsDescription
    Block size
    The block size for the dump stripes, which overrides the default block size for all dump stripes. The block size must be at least one database page and be an exact multiple of the database page size.
    Compression level
    The level of compression for compressed dumps. By default, this option is disabled and set to 0.
    Dump Password
    The password you provide to protect the dump file from unauthorized users. The password must be between 6 and 30 characters long. The default is null.
    Retain days
    The number of days for which the dump is preserved and cannot be overwritten. Default value is 0.
    Dump verification
    Specify whether Backup Server must perform a minimal page-header or full structural row check on the data pages as they are copied to archives. By default, this is unselected. When selected, the default option is header.
    Message destination
    Specify whether the Backup Server must route messages to the client terminal that initiated the dump, or to the operator-console terminal where the Backup Server is running. By default, this is unselected. When selected, the default option is client.
  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. Click Finish to start the backup. SAP Control Center displays backup messages from the server.
Related reference
Dump Configuration Properties