administration-of-an-availability-group-sql-server.md

title	Administration of an availability Group (content index)
description	A reference index linking you to articles describing the basics of administering an Always On availability group, such as altering properties, adding or removing replicas, adding or removing databases, failing over, configuring the listener, etc.
author	MashaMSFT
ms.author	mathoma
ms.reviewer	maghan
ms.date	02/01/2024
ms.service	sql
ms.subservice	availability-groups
ms.topic	reference
helpviewer_keywords	Availability Groups [SQL Server], managing

Administration of an availability group

[!INCLUDE SQL Server]

Managing an existing Always On availability group in [!INCLUDEssnoversion] involves one or more of the following tasks:

• Altering the properties of an existing availability replica, for example to change client connection access (for configuring readable secondary replicas), changing its failover mode, availability mode, or session timeout setting.
• Adding or removing secondary replicas.
• Adding or removing a database.
• Suspending or resuming a database.
• Performing a planned manual failover (a manual failover) or a forced manual failover (a forced failover).
• Creating or configuring an availability group listener.
• Managing readable secondary replicas for a given availability group. This involves configuring one or more replicas to read-only access when running under the secondary role, and configuring read-only routing.
• Managing backups on secondary replicas for a given availability group. This involves configuring where you prefer that backup jobs run and then scripting backup jobs to implement your backup preference. you need to script backup jobs for every database in the availability group on every instance of [!INCLUDE ssNoVersion] that hosts an availability replica.
• Deleting an availability group.
• Cross-cluster migration of Always On Availability Groups for OS upgrade

Configure an existing availability group

• Add a Secondary Replica to an Availability Group (SQL Server)

• Remove a Secondary Replica from an Availability Group (SQL Server)

• Add a Database to an Availability Group (SQL Server)

• Remove a Secondary Database from an Availability Group (SQL Server)

• Remove a Primary Database from an Availability Group (SQL Server)

• Configure the Flexible Failover Policy to Control Conditions for Automatic Failover (Always On Availability Groups)

Manage an availability group

• Configure Backup on Availability Replicas (SQL Server)

• Perform a Planned Manual Failover of an Availability Group (SQL Server)

• Perform a Forced Manual Failover of an Availability Group (SQL Server)

• Remove an Availability Group (SQL Server)

Manage an availability replica

• Add a Secondary Replica to an Availability Group (SQL Server)

• Join a Secondary Replica to an Availability Group (SQL Server)

• Remove a Secondary Replica from an Availability Group (SQL Server)

• Change the Availability Mode of an Availability Replica (SQL Server)

• Change the Failover Mode of an Availability Replica (SQL Server)

• 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)

• Change the Session-Timeout Period for an Availability Replica (SQL Server)

Manage an availability database

• Add a Database to an Availability Group (SQL Server)

• Join a Secondary Database to an Availability Group (SQL Server)

• Remove a Primary Database from an Availability Group (SQL Server)

• Remove a Secondary Database from an Availability Group (SQL Server)

• Suspend an Availability Database (SQL Server)

• Resume an Availability Database (SQL Server)

Monitor an availability group

• Monitoring of Availability Groups (SQL Server)

Support migrating availability groups to a new WSFC cluster (cross-cluster migration)

• Change the HADR Cluster Context of Server Instance (SQL Server)

• Take an Availability Group Offline (SQL Server)

Related content

• SQL Server Always On Team Blogs: The official SQL Server Always On Team Blog
• CSS SQL Server Engineers Blogs
• Microsoft White Papers for SQL Server 2012
• Always On Availability Groups (SQL Server)
• Overview of Always On Availability Groups (SQL Server)
• Configuration of a Server Instance for Always On Availability Groups (SQL Server)
• Creation and Configuration of Availability Groups (SQL Server)
• Active Secondaries: Readable Secondary Replicas (Always On Availability Groups)
• Active Secondaries: Backup on Secondary Replicas (Always On Availability Groups)
• Availability Group Listeners, Client Connectivity, and Application Failover (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)
• Overview of Transact-SQL Statements for Always On Availability Groups (SQL Server)
• Overview of PowerShell Cmdlets for Always On Availability Groups (SQL Server)