Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
Use the Always On High Availability tab of the SQL Server Properties dialog box in SQL Server Configuration Manager to enable or disable the Always On Availability Groups feature in SQL Server. Enabling Always On 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 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 SQL Server that supports Always On availability groups.
Enable Always On Availability Groups for only one server instance at a time. After enabling Always On Availability Groups, wait until the SQL Server 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 Always On availability groups, see SQL Server Books Online.
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 SQL Server, 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 SQL Server 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
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 SQL Server Books Online.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Explore IaaS and PaaS solutions for high availability and disaster recovery - Training
Explore IaaS and PaaS solutions for high availability and disaster recovery
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.