Creating a Dump Configuration

System administrators can create a dump configuration using SAP Control Center.

Prerequisites
Agent authentication is required when the wizard must validate user input in the archive directory; otherwise, you can run this wizard without first authenticating the agent.
Task
  1. In the Administration Console view, select ASE Servers > Backup/Recovery > Dump Configurations.
    You see the name of the available dump configurations and the Backup Servers they reside on.
  2. Select New.
  3. On the Introduction screen, select the server in which to create the dump configuration.
  4. On the Dump Configuration Name screen, enter the unique name of the dump configuration you want to create.
  5. On the Options screen, specify:
    InputDescription
    Archive directory
    The name of the stripe directory that holds the dump files. By default, the stripe directory is the directory from which Backup Server is started.
    External API
    The name of the byte stream device to be used for the dump operation.
    Number of stripe devices
    The number of stripe devices to be used for the dump operation. The default value is 1.
    Retry times
    The number of times the server tries to execute the dump operation for nonfatal errors. The range of values is 0 to 5. The default value is 0.
    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.
    Retain days
    The number of days for which the dump is preserved and cannot be overwritten. The default value is 0.
    Compression level
    The level of compression for compressed dumps. By default, this option is disabled and set to 0. See Backing Up and Restoring User Databases in System Administration Guide, Volume II for more information on compression levels.
    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 option 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 option is unselected. When selected, the default option is client.

    Use the drop-down menu on the Options screen to specify the backup server.

    See dump database in Reference Manual: Commands for more information on these parameters.

  6. (Optional) Click Summary to view your selected options.
  7. (Optional) Click Preview to view the SQL syntax the wizard created, then click Save to save the SQL, or Close to close the preview.
Parent topic: Backing Up (Dumping) a Database