Export (0) Print
Expand All
Expand Minimize

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.

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft