Creation and Configuration of Availability Groups (SQL Server)
The topics in this section explain how to deploy a AlwaysOn Availability Groups implementation on instances of SQL Server 2012 that reside on different Windows Server Failover Clustering (WSFC) nodes within a single WSFC failover cluster.
Before you create your first availability group, we strongly recommend that you familiarize yourself with the information in the following topics:
In this Topic:
To configure a server instance for AlwaysOn Availability Groups
-
Enable and Disable AlwaysOn Availability Groups (SQL Server)
-
Create a Database Mirroring Endpoint for AlwaysOn Availability Groups (SQL Server PowerShell)
-
Create a Database Mirroring Endpoint for Windows Authentication (Transact-SQL)
-
Allow a Database Mirroring Endpoint to Use Certificates for Outbound Connections (Transact-SQL)
To get started with configuring AlwaysOn Availability Groups
To create and configure a new availability group
-
Use the New Availability Group Wizard (SQL Server Management Studio)
-
Use the New Availability Group Dialog Box (SQL Server Management Studio)
-
Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server)
-
Create or Configure an Availability Group Listener (SQL Server)
-
Configure Read-Only Access on an Availability Replica (SQL Server)
-
Configure Read-Only Routing for an Availability Group (SQL Server)
-
Join a Secondary Replica to an Availability Group (SQL Server)
-
Start Data Movement on an AlwaysOn Secondary Database (SQL Server)
-
Manually Prepare a Secondary Database for an Availability Group (SQL Server)
-
Join a Secondary Database to an Availability Group (SQL Server)
-
Management of Logins and Jobs for the Databases of an Availability Group (SQL Server)
To troubleshoot
-
Blogs:
AlwaysON - HADRON Learning Series: Worker Pool Usage for HADRON Enabled Databases
SQL Server AlwaysOn Team Blogs: The official SQL Server AlwaysOn Team Blog
-
Videos:
-
Whitepapers:
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery