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

Backup Server must be running. If you are not running Backup Server, the wizard displays a message, such as Default Backup Server is not running, and you cannot proceed. See Utility Guide for details on backupserver.
Enable incremental dumps for the database you are dumping:
```
sp_dboption dbname, 'allow incremental dumps', true
```

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.

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Select one of:
- User Databases
- System Databases
- In-Memory Databases
Click the Name field of the database, then click the drop-down arrow and select Back up.
In the Introduction screen of the Backup Database wizard, select Backup using configuration. Select the configuration to use.
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.

(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:

Options	Description
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.

(Optional) Click Summary to view your selected options.
(Optional) Click Preview to view the SQL statement you generated with your settings. To save a copy of the SQL statement, click Save.
Click Finish to start the backup. SAP Control Center displays backup messages from the server.