load database

Adaptive Server 15.7 SP100 includes changes to the load database command.

The load database command includes a new cumulative type, which allows you to load a backup created with the dump database cumulative keyword. The new command syntax is:

 load database database_name cumulative
   using config[uration] = config_name
   to [compress::[compression_level::]]stripe_device
    [at backup_server_name]
    [density = density_value,
    blocksize = number_bytes,
    capacity = number_kilobytes,
    dumpvolume = volume_name,
    file = file_name]
    [[stripe on [compress::[compression_level::]]stripe_device
    [at backup_server_name]
    ...]...]
    [with { density = density_value,
    blocksize = number_bytes,
    capacity = number_kilobytes,
    compression = compress_level,
    dumpvolume = volume_name,
    file = file_name,
    [dismount | nodismount],
    [nounload | unload],
    retaindays = number_days,
    [noinit | init],
    notify = {client | operator_console} }]

The load database cumulative command supports the same options as load database.

To perform a full restoration, you may specify load database database_name full, however, full is optional. If you do not specify dump type, load database assumes you are performing a full backup.