Include Witness Server (Configure Database Mirroring Security Wizard)

Applies to: SQL Server

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

• Establish a Database Mirroring Session Using Windows Authentication (SQL Server Management Studio)

• Start the Configuring Database Mirroring Security Wizard (SQL Server Management Studio)

Options

Yes
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.

No
Click to configure security without a witness.

See Also

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