sp_dump_history

Allows you to purge records from the dump history file.

The original dump history file is copied to a new file named original_name.XXX, where XXX represents an increasing numerical value (001, 002, and so on).

Syntax

sp_dump_history [  @operation = {'list' | 'purge' | 'listfiles' | 'help'}]
	[, @until_time = 'date'] 
	[, @database_name = 'database_name']
	[, @dump_type = 
		{'DATABASE' | 'TRAN[SACTION]' | 'CONFIG[URATION]'}]
	[, @status = {'success' | 'fail'}]
	[, @file = 'filename']

Parameters

Examples

Usage

The default behavior for sp_dump_history with no parameters is to display the output from its list parameter.

The output for database and transaction dumps differs from that of configuration files.

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

  • dump configuration, dump database, load database in Reference Manual: Commands

  • sp_config_dump

Permissions

The permission checks for sp_dump_history 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

Audit option

Command or access audited

Information in extrainfo
  • Roles– current actve roles.

  • Keywords or options – NULL.

  • Previous value – NULL.

  • Current value – NULL.

  • Other information – all input parameters.

  • Proxy information – original login name, if set proxy in effect.