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

• Getting Started with Always On Availability Groups (SQL Server)

To create and configure a new availability group

• Use the Availability Group Wizard (SQL Server Management Studio)

• Create an Availability Group (Transact-SQL)

• Create an Availability Group (SQL Server PowerShell)

• 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 the Flexible Failover Policy to Control Conditions for Automatic Failover (Always On Availability Groups)

• Configure Backup on Availability Replicas (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

  CSS SQL Server Engineers Blogs

• Whitepapers:

  Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery

  SQL Server Customer Advisory Team Whitepapers

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)