Creation and Configuration of Availability Groups (SQL Server)

The topics in this section explain how to deploy a Always On 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:

Prerequisites, Restrictions, and Recommendations for AlwaysOn 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 AlwaysOn 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 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

• Getting Started with AlwaysOn 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 (AlwaysOn 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 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

• Troubleshoot AlwaysOn Availability Groups Configuration (SQL Server)deleted

• Troubleshoot a Failed Add-File Operation (AlwaysOn Availability Groups)

Related Content

• Blogs:

  AlwaysON - HADRON Learning Series: Worker Pool Usage for HADRON Enabled Databases

  SQL Server AlwaysOn Team Blogs: The official SQL Server AlwaysOn Team Blog

  CSS SQL Server Engineers Blogs

• Videos:

  Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 1: Introducing the Next Generation High Availability Solution

  Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 2: Building a Mission-Critical High Availability Solution Using AlwaysOn

• Whitepapers:

  Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

  Microsoft White Papers for SQL Server 2012

  SQL Server Customer Advisory Team Whitepapers

See Also

Overview of AlwaysOn Availability Groups (SQL Server)
Administration of an Availability Group (SQL Server)
AlwaysOn Policies for Operational Issues with AlwaysOn Availability Groups (SQL Server)
Monitoring of Availability Groups (SQL Server)
AlwaysOn Availability Groups: Interoperability (SQL Server)