DISK REMIRROR Statement

Note In the future, support for SQL Server device mirroring may be discontinued. It is recommended that you use either the mirroring functionality of the Microsoft Windows NT operating system, or hardware-based mirroring if your hardware supports it. For more information about Windows NT mirroring, see the Microsoft Windows NT operating system documentation in the What's New for SQL Server 6.5.

Resumes software mirroring for the SQL Server device.

DISK REMIRROR
    NAME = 'logical_name'

where

NAME

Is the logical name of the database device that you want to discontinue.

Remarks

When a mirrored device is remirrored, it begins by copying all pages from the source device to the mirror device. For large devices, this may take quite some time to complete.

Permission

DISK REMIRROR permission defaults to the system administrator and is not transferable.

Disk Mirroring
Examples

A.    Mirror a Device

This example creates a software mirror for the database device DEVICE8.

In this example, the mirror is written to a file on different logical drive (for better data recoverability, this should also be a separate physical drive).

DISK MIRROR
    NAME = 'DEVICE8',
    MIRROR = 'g:\sqlimage\device8.mir'

B.    Unmirror a Device

This example suspends software mirroring for DEVICE8.

DISK UNMIRROR
    NAME = 'DEVICE8'

C.    Remirror a Device

This example resumes software mirroring for DEVICE8.

DISK REMIRROR
    NAME = 'DEVICE8'

See Also