DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops
high availability
#high-availability#remove-the-witness

Remove the witness

This topic describes how to remove a witness from a database mirroring session in SQL Server by using SQL Server Management Studio or Transact-SQL. At

This topic describes how to remove a witness from a database mirroring session in SQL Server

by using SQL Server Management Studio or Transact-SQL. At any time during a database

mirroring session, the database owner can turn off the witness for a database mirroring

session.

Security

Management Studio

Transact-SQL

After Removing the Witness

Requires ALTER permission on the database.

  1. Connect to the principal server instance and, in the

pane, click the server

name to expand the server tree.

  1. Expand

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