Backing Up a Database or Transaction Log to Multiple Stripes

SAP Control Center lets you dump (back up) a database or transaction log to multiple stripes.

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.

Task

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Select one of:
- User Databases
- System Databases
- Temporary Databases
- Proxy Databases
- In-Memory Databases
- In-Memory Temporary Databases
Click the Name field of the database, then click the drop-down arrow and select Back up.
(Optional) In the Introduction screen of the Backup Database wizard, choose the dump configuration by selecting Backup using configuration.
In the Type of Backup screen, choose whether to back up the entire database (including the transaction log), or only the transaction log.
In the Dump Devices screen, select the dump stripes. This option appears only if you chose a dump configuration selecting Backup using configuration. To add dump devices for the dump operation, click Add:
- Named dump device – select the device.
- Explicit dump device – specify a local dump device as either an absolute path name or a relative path name. When dumping across the network, specify an absolute path name.
  When dumping across the network, you can specify the Backup Server as your remote dump device.

(Optional) The Options screen differs, depending on whether you are using a dump configuration.

If you are a using dump configuration, you can override the values in the dump configuration by selecting Use modified options. The parameters you can change are:

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	A password, between 6 and characters long, to protect the dump file from unauthorized users. The default is null.
Retain days	The number of days for which the dump is preserved and cannot be overwritten. The default value is 0.
Dump verification	Choose whether to perform a minimal header or full structural row check on the data pages.
Message destination	Choose whether messages appear in the client or on the operator console.

Some of these options are part of the dump configuration, but if you change them at dump time, the new values take precedence over the dump configuration.

If you are not using a dump configuration, the parameters you can specify are:

Options	Description
Compression level	The level of compression for compressed dumps. By default, this option is disabled and set to 0.
Block size	The block size for the dump stripes, which overrides the default block size for all dump stripes. The block size must be least one database page, and be an exact multiple of the database page size.
Retain days	The number of days that the dump is preserved and cannot be overwritten. The default value is 0.
Dump password	A password, between 6 and 30 characters long, to protect the dump file from unauthorized users. The default is null.

In the Dump performance screen, specify the amount of data to be dumped. The performance depends on the amount of data and relative speed of the database and dump devices. See sp_dumpoptimize in Reference Manual: Procedures for details on these options:
- Default – the default values.
- Maximum – dumps the entire database without determining which pages are allocated.
- Minimum – dumps only the allocated pages, which results in the smallest possible archive image.
- Advanced – allows you to specify the value of the reserved threshold and the archive space.
(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.