How to: Remove the Witness from a Database Mirroring Session (SQL Server Management Studio)

New: 14 April 2006

You can remove the witness from a session if you are connected to the current principal server.

To remove the witness

  1. Connect to the principal server instance and, in the Object Explorer pane, click the server name to expand the server tree.

  2. Expand Databases, and select the database whose witness you want to remove.

  3. Right-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box.

  4. To remove the witness, delete its server network address from the Witness field.

    Note   If you switch from high-safety mode with automatic failover to high-performance mode, the Witness field is automatically cleared.

See Also


How to: Add or Replace a Database Mirroring Witness (SQL Server Management Studio)


Database Mirroring Witness
Asynchronous Database Mirroring (High-Performance Mode)
Synchronous Database Mirroring (High-Safety Mode)

Help and Information

Getting SQL Server 2005 Assistance