- name: Overview href: overview-of-always-on-availability-groups-sql-server.md items: - name: Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups href: prereqs-restrictions-recommendations-always-on-availability.md - name: Availability Modes href: availability-modes-always-on-availability-groups.md - name: Quickstart items: - name: Getting starrted href: getting-started-with-always-on-availability-groups-sql-server.md - name: Create availability group items: - name: Wizard href: use-the-availability-group-wizard-sql-server-management-studio.md - name: Dialog box href: use-the-new-availability-group-dialog-box-sql-server-management-studio.md - name: Transact-SQL href: create-an-availability-group-transact-sql.md - name: PowerShell href: create-an-availability-group-sql-server-powershell.md - name: Azure virtual machines href: https://docs.microsoft.com/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-overview - name: How-to items: - name: Configuration href: creation-and-configuration-of-availability-groups-sql-server.md items: - name: Enable and Disable AlwaysOn Availability Groups href: enable-and-disable-always-on-availability-groups-sql-server.md - name: Create an endpoint for AlwaysOn Availability Groups (PowerShell) href: database-mirroring-always-on-availability-groups-powershell.md - name: Specify the Endpoint URL When Adding or Modifying an Availability Replica href: specify-endpoint-url-adding-or-modifying-availability-replica.md - name: Join a Secondary Replica to an Availability Group href: join-a-secondary-replica-to-an-availability-group-sql-server.md - name: Start Data Movement on an AlwaysOn Secondary Database href: start-data-movement-on-an-always-on-secondary-database-sql-server.md - name: Manually Prepare a Secondary Database for an Availability Group href: manually-prepare-a-secondary-database-for-an-availability-group-sql-server.md - name: Join a Secondary Database to an Availability Group href: join-a-secondary-database-to-an-availability-group-sql-server.md - name: Add a Secondary Replica to an Availability Group href: add-a-secondary-replica-to-an-availability-group-sql-server.md - name: Use the Add Replica to Availability Group Wizard href: use-the-add-replica-to-availability-group-wizard-sql-server-management-studio.md - name: Use the Add Azure Replica Wizard href: use-the-add-azure-replica-wizard-sql-server.md - name: Add a Database to an Availability Group href: availability-group-add-a-database.md - name: Use the Add Database to Availability Group Wizard href: availability-group-add-database-to-group-wizard.md - name: Create or Configure an Availability Group Listener href: create-or-configure-an-availability-group-listener-sql-server.md - name: Configure Read-Only Routing for an Availability Group href: configure-read-only-routing-for-an-availability-group-sql-server.md - name: Remove a Secondary Database from an Availability Group (SQL Server) href: remove-a-secondary-database-from-an-availability-group-sql-server.md - name: Remove a Primary Database from an Availability Group href: remove-a-primary-database-from-an-availability-group-sql-server.md - name: Remove a Secondary Replica from an Availability Group href: remove-a-secondary-replica-from-an-availability-group-sql-server.md - name: Remove an Availability Group href: remove-an-availability-group-sql-server.md - name: Remove Availability Group Listener href: remove-an-availability-group-listener-sql-server.md - name: Troubleshoot AlwaysOn Availability Groups Configuration href: troubleshoot-always-on-availability-groups-configuration-sql-server.md - name: Administration items: - name: Perform a Planned Manual Failover of an Availability Group href: perform-a-planned-manual-failover-of-an-availability-group-sql-server.md - name: Perform a Forced Manual Failover of an Availability Group href: perform-a-forced-manual-failover-of-an-availability-group-sql-server.md - name: Use the Fail Over Availability Group Wizard href: use-the-fail-over-availability-group-wizard-sql-server-management-studio.md - name: Change the Availability Mode of an Availability Replica href: change-the-availability-mode-of-an-availability-replica-sql-server.md - name: Change the Failover Mode of an Availability Replica href: change-the-failover-mode-of-an-availability-replica-sql-server.md - name: Configure the Flexible Failover Policy to Control Conditions for Automatic Failover href: configure-flexible-automatic-failover-policy.md - name: Configure Backup on Availability Replicas href: configure-backup-on-availability-replicas-sql-server.md - name: Configure Read-Only Access on an Availability Replica href: configure-read-only-access-on-an-availability-replica-sql-server.md - name: Suspend an Availability Database href: suspend-an-availability-database-sql-server.md - name: Resume an Availability Database href: resume-an-availability-database-sql-server.md - name: Change the Session-Timeout Period for an Availability Replica href: change-the-session-timeout-period-for-an-availability-replica-sql-server.md - name: Take an Availability Group Offline href: ../../take-an-availability-group-offline-sql-server.md - name: Change the HADR Cluster Context of Server Instance href: change-the-hadr-cluster-context-of-server-instance-sql-server.md - name: Troubleshoot a Failed Add-File Operation (AlwaysOn Availability Groups) href: troubleshoot-a-failed-add-file-operation-always-on-availability-groups.md - name: Monitoring href: monitoring-of-availability-groups-sql-server.md items: - name: Monitor Availability Groups (T-SQL) href: monitor-availability-groups-transact-sql.md - name: Use the Object Explorer Details to Monitor Availability Groups href: use-object-explorer-details-to-monitor-availability-groups.md - name: View Availability Group Properties href: view-availability-group-properties-sql-server.md - name: View Availability Replica Properties href: view-availability-replica-properties-sql-server.md - name: View Availability Group Listener Properties href: view-availability-group-listener-properties-sql-server.md - name: Concepts items: - name: Configuration items: - name: Failover Clustering and AlwaysOn Availability Groups href: failover-clustering-and-always-on-availability-groups-sql-server.md - name: Failover and Failover Modes href: failover-and-failover-modes-always-on-availability-groups.md - name: Flexible Failover Policy for Automatic Failover of an Availability Group href: flexible-automatic-failover-policy-availability-group.md - name: Management of Logins and Jobs for the Databases of an Availability Group href: ../../logins-and-jobs-for-availability-group-databases.md - name: Administration href: administration-of-an-availability-group-sql-server.md items: - name: Possible Failures During Sessions Between Availability Replicas (SQL Server) href: possible-failures-during-sessions-between-availability-replicas-sql-server.md - name: Backup on Secondary Replicas href: active-secondaries-backup-on-secondary-replicas-always-on-availability-groups.md - name: Readable Secondary Replicas href: active-secondaries-readable-secondary-replicas-always-on-availability-groups.md - name: Upgrade and Update of Availability Group Servers with Minimal Downtime and Data Loss href: upgrading-always-on-availability-group-replica-instances.md - name: Connectivity items: - name: Client connection href: about-client-connection-access-to-availability-replicas-sql-server.md - name: Client connectivity href: ../../listeners-client-connectivity-application-failover.md - name: Always On Client Connectivity href: always-on-client-connectivity-sql-server.md - name: Interoperability href: always-on-availability-groups-interoperability-sql-server.md items: - name: Contained Databases with Always On Availability Groups href: contained-databases-with-always-on-availability-groups-sql-server.md - name: Cross-Database Transactions Not Supported For Database Mirroring or AlwaysOn Availability Groups href: transactions-always-on-availability-and-database-mirroring.md - name: Database Snapshots with AlwaysOn Availability Groups href: database-snapshots-with-always-on-availability-groups-sql-server.md - name: Encrypted Databases with AlwaysOn Availability Groups href: encrypted-databases-with-always-on-availability-groups-sql-server.md - name: FILESTREAM and FileTable with AlwaysOn Availability Groups href: filestream-and-filetable-with-always-on-availability-groups-sql-server.md - name: Prerequisites for Migrating from Log Shipping to AlwaysOn Availability Groups (SQL Server) href: prereqs-migrating-log-shipping-to-always-on-availability-groups.md - name: Remote Blob Store (RBS) and AlwaysOn Availability Groups href: remote-blob-store-rbs-and-always-on-availability-groups-sql-server.md - name: Configure Replication for Always On Availability Groups href: configure-replication-for-always-on-availability-groups-sql-server.md - name: Maintaining an AlwaysOn Publication Database href: maintaining-an-always-on-publication-database-sql-server.md - name: Replication Subscribers and AlwaysOn Availability Groups href: replication-subscribers-and-always-on-availability-groups-sql-server.md - name: Replication, Change Tracking, Change Data Capture, and AlwaysOn Availability Groups href: replicate-track-change-data-capture-always-on-availability.md - name: Analysis Services with Always On Availability Groups href: analysis-services-with-always-on-availability-groups.md - name: Reporting Services with AlwaysOn Availability Groups href: reporting-services-with-always-on-availability-groups-sql-server.md - name: Service Broker with AlwaysOn Availability Groups href: service-broker-with-always-on-availability-groups-sql-server.md - name: Reference items: - name: Overview of Transact-SQL Statements for AlwaysOn Availability Groups href: transact-sql-statements-for-always-on-availability-groups.md - name: Overview of PowerShell Cmdlets for AlwaysOn Availability Groups href: overview-of-powershell-cmdlets-for-always-on-availability-groups-sql-server.md - name: Availability group policies href: always-on-policies-for-operational-issues-always-on-availability.md items: - name: Use AlwaysOn Policies to View the Health of an Availability Group href: use-always-on-policies-to-view-the-health-of-an-availability-group-sql-server.md - name: Use the AlwaysOn Dashboard (SQL Server Management Studio) href: use-the-always-on-dashboard-sql-server-management-studio.md - name: Options (SQL Server AlwaysOn, Dashboard Page) href: options-sql-server-always-on-dashboard-page.md - name: Policy Evaluation Result (AlwaysOn) href: policy-evaluation-result-always-on.md - name: WSFC cluster service is offline href: wsfc-cluster-service-is-offline.md - name: Availability group is offline href: availability-group-is-offline.md - name: Availability group is not ready for automatic failover href: availability-group-is-not-ready-for-automatic-failover.md - name: Some availability replicas are not synchronizing data href: some-availability-replicas-are-not-synchronizing-data.md - name: Some synchronous replicas are not synchronized href: some-synchronous-replicas-are-not-synchronized.md - name: Some availability replicas do not have a healthy role href: some-availability-replicas-do-not-have-a-healthy-role.md - name: Some availability replicas are disconnected href: some-availability-replicas-are-disconnected.md - name: Availability replica does not have a healthy role href: availability-replica-does-not-have-a-healthy-role.md - name: Availability replica is disconnected href: availability-replica-is-disconnected.md - name: Data synchronization state of availability database is not healthy href: data-synchronization-state-of-availability-database-is-not-healthy.md - name: Availability replica is not joined href: availability-replica-is-not-joined.md - name: Availability database is suspended href: availability-database-is-suspended.md - name: Secondary database is not joined href: secondary-database-is-not-joined.md - name: Data synchronization state of some availability database is not healthy href: data-synchronization-state-of-some-availability-database-is-not-healthy.md - name: Availability Group Properties href: availability-group-properties-new-availability-group-general-page.md items: - name: Availability Replica Properties (General Page) href: availability-replica-properties-general-page.md - name: "Availability Group Properties: New Availability Group (Backup Preferences Page)" href: availability-group-properties-new-availability-group-backup-preferences-page.md - name: Availability Group Wizard items: - name: Add IP Address Dialog Box href: add-ip-address-dialog-box-sql-server-management-studio.md - name: Specify Availability Group Name Page href: specify-availability-group-name-page.md - name: Select Databases Page href: select-databases-page-new-availability-group-wizard-and-add-database-wizard.md - name: Specify Replicas Page href: specify-replicas-page-new-availability-group-wizard-add-replica-wizard.md - name: Select Initial Data Synchronization Page href: select-initial-data-synchronization-page-always-on-availability-group-wizards.md - name: Validation Page href: validation-page-always-on-availability-group-wizards.md - name: Summary Page href: summary-page-always-on-availability-group-wizards.md - name: Progress Page href: progress-page-always-on-availability-group-wizards.md - name: Results Page href: results-page-always-on-availability-group-wizards.md - name: Use the New Availability Group Dialog Box href: use-the-new-availability-group-dialog-box-sql-server-management-studio.md - name: Connect to Existing Secondary Replicas Page (Add Replica Wizard and Add Databases Wizard) href: connect-to-existing-secondary-replicas-page.md