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. The name 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

disk remirror permission defaults to the System Administrator and is not transferable. You must be using the master database to use disk remirror.

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 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