Creates a backup of the SAP ASE configuration files into a specified dump directory. The copy is created by the SAP ASE server, not the Backup Server.
dump config[uration] to dump_dir
[with {
file = (file_option, file_option...)}
} ]
server_config[uration] – server configuration file.
dump_history – dump history file.
cluster_config[uration] – cluster configuration file. In cluster configurations in SAP ASE Cluster Edition, each instance can have its own server configuration file. The dump configuration command dumps the server configuration files of the instance on which it was executed. The cluster configuration file is generated from the quorum device, and is named cluster.cfg with the current timestamp appended.
'all' – (default) all listed (known) configuration files.
If you omit file_option, all existing configuration files are backed up.
dump configuration to "/myserver/test/backupserver" with file = "server_config"
dump configuration
The list_option value 'all' must be in either single or double quotes.
dump database, load database, load transaction, online database
Backing Up and Restoring User Databases in the System Administration Guide.
sp_addumpdevice, sp_dboption, sp_dropdevice, sp_helpdevice, sp_hidetext, sp_logdevice, sp_volchanges in Reference Manual: Procedures
ANSI SQL – Compliance level: Transact-SQL extension.
The permission checks for dump configuration differ based on your granular permissions settings.
| Setting | Description |
|---|---|
Enabled | With granular permissions enabled, you must be a user with manage dump configuration privilege. |
Disabled | With granular permissions disabled, you must be a user with oper_role or sa_role. |
Values in event and extrainfo columns of sysaudits are:
| Information | Values |
|---|---|
Event | 147 |
Audit option | dump_config |
Command or access audited | dump configuration |
Information in extrainfo |
|