Reference for the creation and configuration of Always On availability groups
Applies to: SQL Server
The topics in this section explain how to deploy a Always On availability groups implementation on instances of SQL Server 2012 (11.x) 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:
Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)
This topic describes the prerequisites, restrictions, and recommendations for computers; WSFC nodes; instances of SQL Server; availability groups, replicas, and databases. This topic also contains information about security considerations.
Getting Started with Always On Availability Groups (SQL Server)
Contains information about the steps for configuring a server instance, creating an availability group, configuring the availability group for client connections, managing availability groups, and monitoring availability groups.
Related Tasks
To configure a server instance for Always On availability groups
Enable and Disable Always On Availability Groups (SQL Server)
Create a Database Mirroring Endpoint for Always On 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 Always On Availability Groups
To create and configure a new availability group
Use the 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 Always On 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
Troubleshoot Always On Availability Groups Configuration (SQL Server)
Troubleshoot a Failed Add-File Operation (Always On Availability Groups)
Related Content
Blogs:
Always On - HADRON Learning Series: Worker Pool Usage for HADRON Enabled Databases
SQL Server Always On Team Blogs: The official SQL Server Always On Team Blog
Whitepapers:
Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery
See Also
Overview of Always On Availability Groups (SQL Server)
Administration of an Availability Group (SQL Server)
Always On Policies for Operational Issues with Always On Availability Groups (SQL Server)
Monitoring of Availability Groups (SQL Server)
Always On Availability Groups: Interoperability (SQL Server)