dump configuration

Description

Creates a backup of the Adaptive Server configuration files into a specified dump directory. The copy is created by the Adaptive Server, not the Backup Server.

Syntax

dump config[uration]
	[with {
		file = (file_option, file_option...)}
	} ]

Parameters

with file = (file_option, file_option...)}: allows you to make the backup of one or more files based on the options you specify.

Valid file_option values include:

server_config[uration] – server configuration file.

dump_history – dump history file.

cluster_config[uration] – cluster configuration file.

In cluster configurations in Adaptive Server 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.

Examples

Example 1

Creates a backup of the server configuration file and the dump history file:

dump configuration 
    with file = (server_config, dump_history)

Example 2

Creates a backup of all listed (known) configuration files:

dump configuration

Usage

The list_option value 'all' must be in either single or double quotes.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for dump configuration differ based on your granular permissions settings.

Granular permissions enabled	With granular permissions enabled, you must be a user with manage dump configuration privilege.
Granular permissions disabled	With granular permissions disabled, you must be a user with oper_role or sa_role.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event	Audit option	Command or access audited	Information in extrainfo
147	dump_config	dump configuration	Roles – current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – User-supplied config file options Proxy information – Original login name, if set proxy is in effect