Skip to content

Latest commit

 

History

History
37 lines (29 loc) · 1.63 KB

File metadata and controls

37 lines (29 loc) · 1.63 KB
title Include Witness Server (Configure Database Mirroring Security Wizard) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology high-availability
ms.topic conceptual
f1_keywords
sql12.swb.configdbmsecurwiz.inclwitness.f1
ms.assetid f04b38a4-f4e2-4d4c-bdac-7cc70e5a5684
author MikeRayMSFT
ms.author mikeray
manager craigg

Include Witness Server (Configure Database Mirroring Security Wizard)

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

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