Enabling AlwaysOn in SQL Server
In this recipe, we will enable the AlwaysOn feature in SQL Server.
Getting ready
Check whether the AlwaysOn feature is enabled. You can do this from the GUI by launching SQL Server Configuration Manager, right-clicking on the SQL Server database engine service, and selecting Properties. Click on the AlwaysOn High Availability tab:
You can also do this using PowerShell by running the following code:
$instanceName = "SQL01" $server = New-Object Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName #check AlwaysOn $server.IsHadrEnabled
To check this feature against multiple nodes, you can use the following ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.