Administration of an Availability Group (SQL Server)
Managing an existing AlwaysOn availability group in SQL Server 2012 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 SQL Server that hosts an availability replica.
Deleting an availability group.
Cross-cluster migration of AlwaysOn Availability Groups for OS upgrade
In This Topic:
Related Tasks
Related Content
Related Tasks
To 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)
Remove a Secondary Database from an Availability Group (SQL Server)
Remove a Primary Database from an Availability Group (SQL Server)
To manage an availability group
Perform a Planned Manual Failover of an Availability Group (SQL Server)
Perform a Forced Manual Failover of an Availability Group (SQL Server)
To 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 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)
To manage an availability database
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)
To monitor an availability group
To support migrating availability groups to a new WSFC cluster (cross-cluster migration)
[Top]
Related Content
**Blogs: **
SQL Server AlwaysOn Team Blogs: The official SQL Server AlwaysOn Team Blog
**Videos: **
**White papers: **
[Top]
Zobacz także
Koncepcje
Overview of AlwaysOn Availability Groups (SQL Server)
Active Secondaries: Readable Secondary Replicas (AlwaysOn Availability Groups)
Active Secondaries: Backup on Secondary Replicas (AlwaysOn Availability Groups)
Availability Group Listeners, Client Connectivity, and Application Failover (SQL Server)
Overview of Transact-SQL Statements for AlwaysOn Availability Groups (SQL Server)
Overview of PowerShell Cmdlets for AlwaysOn Availability Groups (SQL Server)
Inne zasoby
AlwaysOn Availability Groups (SQL Server)
Configuration of a Server Instance for AlwaysOn Availability Groups (SQL Server)
Creation and Configuration of Availability Groups (SQL Server)
AlwaysOn Policies for Operational Issues with AlwaysOn Availability Groups (SQL Server)