Skip to content

sql-server-properties-alwayson-high-availability-tab.md

Latest commit

 

History

History
50 lines (35 loc) · 3.28 KB

sql-server-properties-alwayson-high-availability-tab.md

File metadata and controls

50 lines (35 loc) · 3.28 KB
title SQL Server Properties (AlwaysOn High Availability Tab) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology configuration
ms.topic conceptual
ms.assetid d8630923-a600-4f1c-aca1-027453a3ec82
author mikeraymsft
ms.author mikeray
manager craigg

SQL Server Properties (AlwaysOn High Availability Tab)

Use the AlwaysOn High Availability tab of the SQL Server Properties dialog box in [!INCLUDEssNoVersion] Configuration Manager to enable or disable the AlwaysOn Availability Groups feature in [!INCLUDEssCurrent]. Enabling AlwaysOn Availability Groups is a prerequisite for an instance of [!INCLUDEssNoVersion] to use availability groups as a high availability and disaster recovery solution.

Prerequisites

To be enabled for AlwaysOn Availability Groups, a server instance must meet the following prerequisites:

  • The server instance must reside on a Windows Server Failover Clustering (WSFC) node.

  • To be in the same availability group, instances must be in the same WSFC cluster. An availability group cannot span WSFC clusters.

  • The server instance must be running an edition of [!INCLUDEssNoVersion] that supports [!INCLUDEssHADR].

  • Enable AlwaysOn Availability Groups for only one server instance at a time. After enabling AlwaysOn Availability Groups, wait until the [!INCLUDEssNoVersion] service has restarted before you enable the next server instance.

Note

For information about feature support and for information about additional prerequisites, restrictions, and recommendations for [!INCLUDEssHADR], see [!INCLUDEssCurrent] Books Online.

Dialog Options

Windows failover cluster name
Displays the name of the WSFC cluster in which the local computer is a node.

Enable AlwaysOn Availability Groups
Use this check box to enable or disable AlwaysOn Availability Groups on this instance of [!INCLUDEssNoVersion], as follows:

  • If this check box is empty, AlwaysOn Availability Groups is currently disabled. To enable AlwaysOn Availability Groups, select this check box, click OK, and manually restart the [!INCLUDEssNoVersion] service.

  • If this check box is already selected, AlwaysOn Availability Groups is currently enabled. To disable AlwaysOn Availability Groups, uncheck the check box and click OK. This causes the server instance to restart.

    [!TIP]
    After disabling AlwaysOn Availability Groups, you should remove any local availability replicas from the server instance. If you remove the last replica of a given availability group, you should also remove the group.

UIElement List

Note

For more information about follow up after you disable AlwaysOn Availability Groups and for information about how to create and configure availability groups, see [!INCLUDEssCurrent] Books Online.