SQL Server Properties (AlwaysOn High Availability Tab)

 

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

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 SQL Server that supports Always On Availability Groups.

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

System_CAPS_ICON_note.jpg Note


For information about feature support and for information about additional prerequisites, restrictions, and recommendations for Always On Availability Groups, see SQL Server 2014 Books Online.

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 SQL Server, 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 SQL Server 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.

    System_CAPS_ICON_tip.jpg 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.

System_CAPS_ICON_note.jpg 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 SQL Server 2014 Books Online.

Show: