Backing Up a Database Using a Dump Configuration

SAP Control Center lets you dump (back up) a database using a dump configuration.

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.
Task
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • In-Memory Databases
    • In-Memory Temporary 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, choose the dump configuration by selecting Backup using configuration.
  5. In the Type of Backup screen, choose whether to back up the entire database (including the transaction log), or only the transaction log.
  6. (Optional) The selections in the Options screen are not part of the dump configuration, but are applied to the dump database and dump transaction commands. This means that some of these options take precedence over the configured parameter value stored in the dump configuration file for a particular dump operation. See Reference Manual: Commands for information on dump database and dump transaction options. To overwrite the options you previously selected for the dump configuration, select Use modified options.
    OptionsDescription
    Block size
    The block size for the dump operation, which overrides the default block size for the device. For optimal performance, specify the block size as a power of 2. The default value is 0.
    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 30 characters, protect the dump file from unauthorized users. The default is null.
    Retain days
    The number of days that the dump is preserved and cannot be overwritten. The 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. Click Finish to start the backup. SAP Control Center displays backup messages from the server.
Parent topic: Backing Up (Dumping) a Database
Related reference
Dump Configuration Properties