quiesce database

Suspends and resumes updates to a specified list of databases.

Syntax

quiesce database tag_name hold database_list [for external dump] 
	[to manifest_file [with override]]

or:

quiesce database tag_name release

Parameters

Examples

Usage

See also sp_helpdb, sp_who in Reference Manual: Procedures.

Permissions

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

SettingDescription
Enabled

With granular permissions enabled, you must be a user with quiesce any database privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

96

Audit option

quiesce

Command or access audited

quiesce database

Information in extrainfo
  • Roles – current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – NULL

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

Related reference
dump database
dump transaction