disk remirror

Description

Restarts disk mirroring after it is stopped by failure of a mirrored device, or temporarily disabled by the disk unmirror command.

Syntax

disk remirror 
	name = "device_name"

Parameters

name

is the name of the database device that you want to remirror, which is recorded in the name column of the sysdevices table, and must be enclosed in single or double quotes.

Examples

Example 1

Resumes software mirroring on the database device user_disk:

disk remirror 
  name = "user_disk"

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for disk remirror differ based on your granular permissions settings. You must be using the master database to use disk remirror.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage disk privilege.

Granular permissions disabled

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

disk remirror permission is not transferable.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

25

disk

disk remirror

  • Roles – current active roles

  • Keywords or optionsdisk remirror

  • Previous value – NULL

  • Current value – NULL

  • Other information – name of the disk

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

See also

Commands alter database, create database, disk init, disk mirror, disk refit, disk reinit, disk unmirror, dump database, dump transaction, load database, load transaction

System procedures sp_diskdefault, sp_helpdevice, sp_logdevice

Utilities dataserver, startserver