From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Unmirror operation lets you execute a DISK UNMIRROR command against a database device, suspending disk mirroring. Options include specifying the primary or secondary device, and whether unmirroring is permanent or temporary.

Platform Availability

To Suspend Mirroring for a Database Device

  1. Initiate an Unmirror action against a database device. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying the settings on the Unmirror wizard:
Step Description

Action Options

Displays the database device you selected and lets you work with the following settings:


Specifies whether to disable the PRIMARY device or the SECONDARY, or mirror, device.


Specifies RETAIN (unmirroring is temporary) or REMOVE (unmirroring is permanent).


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Preview the DDL generated from your choices. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.