| title | Creation and Configuration of Availability Groups (SQL Server) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 05/17/2016 | |||
| ms.prod | sql-server-2016 | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | article | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 7f89fab8-6ee2-4273-9de0-e594bfb9407f | |||
| caps.latest.revision | 30 | |||
| author | MikeRayMSFT | |||
| ms.author | mikeray | |||
| manager | jhubbard |
The topics in this section explain how to deploy a [!INCLUDEssHADR] implementation on instances of [!INCLUDEssSQL11] 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 [!INCLUDEssNoVersion]; 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.
In this Topic:
To configure a server instance for [!INCLUDEssHADR]
-
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)
-
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
-
Videos:
-
Whitepapers:
Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery
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)