Include Witness Server (Configure Database Mirroring Security Wizard)


Applies To: SQL Server 2016

Use this page to specify whether you want to include a witness server in this security configuration for database mirroring.

To configure database mirroring by using SQL Server Management Studio

Click to include a witness server instance in the security configuration. The witness is necessary for high-safety mode with automatic failover, which supports automatic failover to the mirror server instance if the principal server instance fails.

Click to configure security without a witness.

Database Properties (Mirroring Page)
Database Mirroring (SQL Server)
Database Mirroring Witness

Community Additions