# [Overview](overview-of-always-on-availability-groups-sql-server.md) ## [Interoperability](always-on-availability-groups-interoperability-sql-server.md) ## [Technology and capabilities](always-on-availability-groups-sql-server.md) # Quickstart ## [Getting started](getting-started-with-always-on-availability-groups-sql-server.md) ## [Prerequisites, restrictions, and recommendations](prereqs-restrictions-recommendations-always-on-availability.md) ## [Creation and configuration](creation-and-configuration-of-availability-groups-sql-server.md) ### [Wizard](use-the-availability-group-wizard-sql-server-management-studio.md) ### [Dialog](use-the-new-availability-group-dialog-box-sql-server-management-studio.md) ### [Transact-SQL](create-an-availability-group-transact-sql.md) ### [PowerShell](create-an-availability-group-sql-server-powershell.md) ### [Azure virtual machines](http://docs.microsoft.com/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-overview) ## [Listener](create-or-configure-an-availability-group-listener-sql-server.md) # Concepts ## [Automatic seeding for secondary replicas](automatic-seeding-secondary-replicas.md) ## [Availability group policies](always-on-policies-for-operational-issues-always-on-availability.md) ## [Availability modes](availability-modes-always-on-availability-groups.md) ## [Backup on secondary](active-secondaries-backup-on-secondary-replicas-always-on-availability-groups.md) ## [Basic availability groups](basic-availability-groups-always-on-availability-groups.md) ## [Client connection](about-client-connection-access-to-availability-replicas-sql-server.md) ## [Client connectivity](always-on-client-connectivity-sql-server.md) ## [Distributed availability groups](distributed-availability-groups.md) ## [Domain independent availability groups](domain-independent-availability-groups.md) ## [Enhanced Database Failover ](enhanced-database-failover.md) ### [Database health detection](sql-server-always-on-database-health-detection-failover-option.md) ## [Failover clustering and availability groups](failover-clustering-and-always-on-availability-groups-sql-server.md) ## [Failover and failover modes](failover-and-failover-modes-always-on-availability-groups.md) ## [Flexible failover policy for automatic failover](flexible-automatic-failover-policy-availability-group.md) ## Interoperability with other features ### [Change tracking and change data capture](replicate-track-change-data-capture-always-on-availability.md) ### [Configure replication](configure-replication-for-always-on-availability-groups-sql-server.md) ### [Contained databases](contained-databases-with-always-on-availability-groups-sql-server.md) ### [Database snapshots](database-snapshots-with-always-on-availability-groups-sql-server.md) ### [Distributed transactions](transactions-always-on-availability-and-database-mirroring.md) #### [Cluster DTC](cluster-dtc-for-sql-server-2016-availability-groups.md) ### [Encrypted databases](encrypted-databases-with-always-on-availability-groups-sql-server.md) ### [Failover cluster instances](analysis-services-with-always-on-availability-groups.md) ### [FILESTREAM and FileTable](filestream-and-filetable-with-always-on-availability-groups-sql-server.md) ### [Migrating from log shipping](prereqs-migrating-log-shipping-to-always-on-availability-groups.md) ### [Remote blob store (RBS)](remote-blob-store-rbs-and-always-on-availability-groups-sql-server.md) #### [Publication database](maintaining-an-always-on-publication-database-sql-server.md) #### [Subscribers](replication-subscribers-and-always-on-availability-groups-sql-server.md) ### [Reporting Services](reporting-services-with-always-on-availability-groups-sql-server.md) ### [Service Broker](service-broker-with-always-on-availability-groups-sql-server.md) ## [Listeners, clients, and failover](listeners-client-connectivity-application-failover.md) ## [Logins and jobs](logins-and-jobs-for-availability-group-databases.md) ## [Possible failures during sessions between replicas](possible-failures-during-sessions-between-availability-replicas-sql-server.md) ## [Read-scale only](read-scale-availability-groups.md) ## [Readable secondary](active-secondaries-readable-secondary-replicas-always-on-availability-groups.md) # [How-to guides](administration-of-an-availability-group-sql-server.md) ## Configure availability group ### [Change replica availability](change-the-availability-mode-of-an-availability-replica-sql-server.md) ### [Change replica failover mode](change-the-failover-mode-of-an-availability-replica-sql-server.md) ### [Configure automatic seeding](automatically-initialize-always-on-availability-group.md) ### [Configure backup on replicas](configure-backup-on-availability-replicas-sql-server.md) ### [Configure flexible failover policy](configure-flexible-automatic-failover-policy.md) ### [Configure backup on replicas](configure-backup-on-availability-replicas-sql-server.md) ### [Configure distributed availability groups](configure-distributed-availability-groups.md) ### [Configure for distributed transactions](configure-availability-group-for-distributed-transactions.md) ### [Configure read-only access replica](configure-read-only-access-on-an-availability-replica-sql-server.md) ### [Configure read-only routing](configure-read-only-routing-for-an-availability-group-sql-server.md) ### [Remove listener](remove-an-availability-group-listener-sql-server.md) ### [Join a secondary database](join-a-secondary-database-to-an-availability-group-sql-server.md) ### [Start data movement](start-data-movement-on-an-always-on-secondary-database-sql-server.md) ### [Manually prepare secondary database](manually-prepare-a-secondary-database-for-an-availability-group-sql-server.md) ### [Specify the endpoint URL when adding or modifying a replica](specify-endpoint-url-adding-or-modifying-availability-replica.md) ### [Join secondary replica](join-a-secondary-replica-to-an-availability-group-sql-server.md) ### [Tune compression](tune-compression-for-availability-group.md) ### [Troubleshoot configuration](troubleshoot-always-on-availability-groups-configuration-sql-server.md) ## [Configure instance](configuration-of-a-server-instance-for-always-on-availability-groups-sql-server.md) ### [Enable and disable](enable-and-disable-always-on-availability-groups-sql-server.md) ### [Create database mirroring endpoint (PowerShell)](database-mirroring-always-on-availability-groups-powershell.md) ### [Create clustered DTC](create-clustered-dtc-for-an-always-on-availability-group.md) ## [Monitoring](monitoring-of-availability-groups-sql-server.md) ### [Transact-SQL](monitor-availability-groups-transact-sql.md) ### [SQL Server Management Studio](use-object-explorer-details-to-monitor-availability-groups.md) ### [View availability group properties](view-availability-group-properties-sql-server.md) ### [View replica properties](view-availability-replica-properties-sql-server.md) ### [View listener properties](view-availability-group-listener-properties-sql-server.md) ## Operation ### Add Database #### [Dialog](availability-group-add-a-database.md) #### [Wizard](availability-group-add-database-to-group-wizard.md) ### [Add replica - wizard](use-the-add-replica-to-availability-group-wizard-sql-server-management-studio.md) ### [Add secondary replica](add-a-secondary-replica-to-an-availability-group-sql-server.md) ### [Change session-timeout period](change-the-session-timeout-period-for-an-availability-replica-sql-server.md) ### [Change the HADR cluster context](change-the-hadr-cluster-context-of-server-instance-sql-server.md) ### [Fail over - wizard](use-the-fail-over-availability-group-wizard-sql-server-management-studio.md) ### [Forced manual failover](perform-a-forced-manual-failover-of-an-availability-group-sql-server.md) ### [Planned manual failover](perform-a-planned-manual-failover-of-an-availability-group-sql-server.md) ### [Remove availability group](remove-an-availability-group-sql-server.md) ### [Remove primary database](remove-a-primary-database-from-an-availability-group-sql-server.md) ### [Remove replica](remove-a-secondary-replica-from-an-availability-group-sql-server.md) ### [Remove secondary database](remove-a-secondary-database-from-an-availability-group-sql-server.md) ### [Resume availability database](resume-an-availability-database-sql-server.md) ### [Suspend availability database](suspend-an-availability-database-sql-server.md) ### [Take availability group offline](take-an-availability-group-offline-sql-server.md) ### [Troubleshoot failed add-file](troubleshoot-a-failed-add-file-operation-always-on-availability-groups.md) ### [Upgrading replica instances](upgrading-always-on-availability-group-replica-instances.md) ### [View health with policies](use-always-on-policies-to-view-the-health-of-an-availability-group-sql-server.md) # References ## [PowerShell Cmdlets](overview-of-powershell-cmdlets-for-always-on-availability-groups-sql-server.md) ## [Transact-SQL](transact-sql-statements-for-always-on-availability-groups.md) # Resources ## Dialogs and Wizards ### [Add IP Address Dialog Box](add-ip-address-dialog-box-sql-server-management-studio.md) ### [Configure Read-Only Routing for an Availability Group](configure-read-only-routing-for-an-availability-group-sql-server.md) ### [Remove Availability Group Listener](remove-an-availability-group-listener-sql-server.md) ### [Specify Availability Group Options Page (New Availability Group Wizard/Add Database Wizard)](specify-availability-group-name-page.md) ### [Select Databases Page (New Availability Group Wizard and Add Database Wizard)](select-databases-page-new-availability-group-wizard-and-add-database-wizard.md) ### [Specify Replicas Page (New Availability Group Wizard: Add Replica Wizard)](specify-replicas-page-new-availability-group-wizard-add-replica-wizard.md) ### [Enter Passwords Page (Add Replica Wizard)](enter-passwords-page-add-replica-wizard.md) ### [Select Initial Data Synchronization Page (Always On Availability Group Wizards)](select-initial-data-synchronization-page-always-on-availability-group-wizards.md) ### [Validation Page (Always On Availability Group Wizards)](validation-page-always-on-availability-group-wizards.md) ### [Summary Page (Always On Availability Group Wizards)](summary-page-always-on-availability-group-wizards.md) ### [Progress Page (Always On Availability Group Wizards)](progress-page-always-on-availability-group-wizards.md) ### [Results Page (Always On Availability Group Wizards)](results-page-always-on-availability-group-wizards.md) ### [Availability Group - Connect Existing Secondary Replicas Page](connect-to-existing-secondary-replicas-page.md) ## [Use the Always On Dashboard (SQL Server Management Studio)](use-the-always-on-dashboard-sql-server-management-studio.md) ### [Options (SQL Server Always On, Dashboard Page)](options-sql-server-always-on-dashboard-page.md) ### [Policy Evaluation Result (Always On)](policy-evaluation-result-always-on.md) ### [Availability Replica Properties (General Page)](availability-replica-properties-general-page.md) ### [Availability Group Properties: New Availability Group (General Page)](availability-group-properties-new-availability-group-general-page.md) ### [Availability Group Properties: New Availability Group (Backup Preferences Page)](availability-group-properties-new-availability-group-backup-preferences-page.md) ## Policies ### [Availability database is suspended](availability-database-is-suspended.md) ### [Availability group is offline](availability-group-is-offline.md) ### [Availability group is not ready for automatic failover](availability-group-is-not-ready-for-automatic-failover.md) ### [Availability replica does not have a healthy role](availability-replica-does-not-have-a-healthy-role.md) ### [Availability replica is disconnected](availability-replica-is-disconnected.md) ### [Availability replica is not joined](availability-replica-is-not-joined.md) ### [Data synchronization state of availability database is not healthy](data-synchronization-state-of-availability-database-is-not-healthy.md) ### [Data synchronization state of some availability database is not healthy](data-synchronization-state-of-some-availability-database-is-not-healthy.md) ### [Secondary database is not joined](secondary-database-is-not-joined.md) ### [Some availability replicas are disconnected](some-availability-replicas-are-disconnected.md) ### [Some availability replicas are not synchronizing data](some-availability-replicas-are-not-synchronizing-data.md) ### [Some availability replicas do not have a healthy role](some-availability-replicas-do-not-have-a-healthy-role.md) ### [Some synchronous replicas are not synchronized](some-synchronous-replicas-are-not-synchronized.md) ### [WSFC cluster service is offline](wsfc-cluster-service-is-offline.md)