Dumping a Database Using a Dump Configuration

Sybase 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.
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 you want to back up.
  4. Click the arrow and select Back up.
  5. In the Backup Database wizard, choose from these options:
    InputDescription
    Introduction
    To back up the database using an existing dump configuration, select the Backup using configuration option, then select the dump configuration name from the list.
    Type of backup
    Choose the type of backup: entire database or transaction log.
    Options
    These options are disabled unless you click Use modified option. These options are not part of the dump configuration, but are options for 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.
    • Block size – 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. Default value is 0.
    • Compression level – level of compression for compressed dumps. By default, this option is disabled.
    • 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 – number of days that the dump is preserved and cannot be overwritten. Default value is 0.
    • Volume reinitialization – whether the volume must be reinitialized. Default is noinit.
    • Dump verification – whether Backup Server must perform a minimal page-header or full structural row check on the data pages as they are copied to archives. Default is header.
    • Message destination – specifies if 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. Default is client.
  6. (Optional) Click Summary to view your selected options.
  7. Click Finish to start the backup. Sybase Control Center displays backup messages from the Adaptive Server.