Skip to content

sql-server-properties-always-on-high-availability-tab.md

Latest commit

 

History

History
52 lines (37 loc) · 3.45 KB

sql-server-properties-always-on-high-availability-tab.md

File metadata and controls

52 lines (37 loc) · 3.45 KB
title SQL Server Properties (Always On High Availability Tab)
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology configuration
ms.topic conceptual
ms.assetid d8630923-a600-4f1c-aca1-027453a3ec82
author MikeRayMSFT
ms.author mikeray
monikerRange >=sql-server-2016||=sqlallproducts-allversions

SQL Server Properties (Always On High Availability Tab)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] Use the Always On High Availability tab of the SQL Server Properties dialog box in [!INCLUDEssNoVersion] Configuration Manager to enable or disable the Always On Availability Groups feature in [!INCLUDEssCurrent]. Enabling Always On 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 Always On 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 Always On Availability Groups for only one server instance at a time. After enabling Always On 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 Always On Availability Groups
Use this check box to enable or disable Always On Availability Groups on this instance of [!INCLUDEssNoVersion], as follows:

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

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

    [!TIP]
    After disabling Always On 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 Always On Availability Groups and for information about how to create and configure availability groups, see [!INCLUDEssCurrent] Books Online.