sp_config_dump

Allows you to list, add, or change dump configurations.

Syntax

sp_config_dump
	[@config_name = ‘configuration_name’
	[, {
		[@stripe_dir = ’stripe_dir_name’,]
		[@ext_api = ’external_api’,]
		[@num_stripes = ’number_of_stripes’,]
		[@retry = ’number_of_retries’,]
		[@blocksize = ’number_of_bytes’,]
		[@compression = ’compression_level’,]
		[@retaindays = ’number_of_days’,]
		[@init = ’[noinit | init]’,]
		[@verify = ’[header | full]’,]
		[@notify = ’[client | operator_console]',]
		[@backup_srv_name = backup_server_name’,]
		} | [‘delete’]
	] ]

Parameters

Examples

Usage

The sp_config_dump procedure does not support tape devices.

See also:
  • dump, load, genddlonly in Reference Manual: Commands

  • For information about dump operations, see the System Administration Guide.

Permissions

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

SettingDescription
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 sa_role or oper_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

exec_procedure

Audit option

Command or access audited

Execution of procedure

Information in extrainfo
  • Roles – current active roles.

  • Keywords or options – NULL.

  • Previous value – NULL.

  • Current value – NULL.

  • Other information – all input parameters.

  • Proxy information – original login name, if set proxy is enabled.