Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Remove the Witness from a Database Mirroring Session (SQL Server Management Studio)
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2015 Microsoft