Adaptive Server 15.7 ESD #2 includes enhancements to the dump and
load commands, which make it easier for you to back up and restore
your databases.
The enhancements include:
- The dump configuration command allows you to back up the
Adaptive Server configuration file, the dump history file, and the cluster
configuration file.
- Dump configurations define options to create a database dump. Backup Server then
uses the configuration to perform a database dump. You can use:
- The dump configuration to create, modify, or list dump configurations,
then use dump database or dump
transaction with the configuration.
- The enforce dump configuration configuration
parameter to enable dump operations to use a dump configuration.
- The configuration group "dump configuration," which represents
user-created dump configurations.
- Dump history:
- Preserve the history of dump database and
dump transaction commands in a dump history file
that Adaptive Server can later use to restore databases, up to a
specified point in time.
- Read the dump history file and regenerate the load sequence of SQL
statements necessary to restore the database.
- Use sp_dump_history to purge dump history
records.
- Use the enable dump history configuration
parameter to disable default updates to the dump history file at the end
of every dump operation.
- Use the dump history
update configuration parameter to specify the name of the
dump history file.
- Dump header – New options to the dump with listonly command:
- create_sql – lists the sequence of disk
init, sp_cacheconfig, create
database, and alter database commands
required to create a target database with the same layout as the source
database.
- load_sql – uses the dump history file to generate a
list of load database and load
transaction commands required to repopulate the database
to a specified point in time.