always-on-availability-groups-interoperability-sql-server.md

title	Always On availability groups: interoperability
description	Describes the different features that can and cannot function alongside an Always On availability group.
author	MashaMSFT
ms.author	mathoma
ms.date	09/15/2021
ms.service	sql
ms.subservice	availability-groups
ms.topic	reference
ms.custom	seodec18
helpviewer_keywords	Availability Groups [SQL Server], about Availability Groups [SQL Server], interoperability

Always On availability groups: interoperability (SQL Server)

[!INCLUDE SQL Server]

This topic documents interoperability of [!INCLUDEssHADR] with other [!INCLUDEssNoVersion] features.

Features that Interoperate with Always On Availability Groups

The following table lists [!INCLUDEssNoVersion] features that interoperate with [!INCLUDEssHADR]. A link in the More Information column indicates that interoperability considerations exist for a given feature.

Feature	More Information
Change data capture	Replication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)
Change tracking	Replication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)
Contained databases	Contained Databases with Always On Availability Groups (SQL Server)
Database encryption	Encrypted Databases with Always On Availability Groups (SQL Server)
Database snapshots	Database Snapshots with Always On Availability Groups (SQL Server)
FILESTREAM and FileTable	FILESTREAM and FileTable with Always On Availability Groups (SQL Server)
Full-text search	Note: Full-Text indexes are synchronized with Always On secondary databases.
Log shipping	Prerequisites for Migrating from Log Shipping to Always On Availability Groups (SQL Server)
Remote Blob Store (RBS)	Remote Blob Store (RBS) and Always On Availability Groups (SQL Server)
Replication	Configure Replication for Always On Availability Groups (SQL Server) Maintaining an Always On Publication Database (SQL Server) Replication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server) Replication Subscribers and Always On Availability Groups (SQL Server)
Analysis Services	Analysis Services with Always On Availability Groups
Reporting Services	Utilize read only secondary replicas as a reporting data source and reduce the load on your primary read-write replica. Reporting Services with Always On Availability Groups (SQL Server)
Service Broker	Service Broker with Always On Availability Groups (SQL Server)
SQL Server Agent

Features that Interoperate with Always On Availability Groups with Restrictions

The following features interoperate with [!INCLUDEssHADR] with specific restrictions. See the linked topics for details.

• Cross-database transactions within the same SQL Server instance require [!INCLUDEsssql16-md] SP2 and Windows Server 2016 or later, with some patching requirements. For more information, see Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server)
• Distributed transactions require [!INCLUDEsssql16-md] SP2 and Windows Server 2012 R2 or later, with some patching requirements. For more information, see Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server)
• Query statistics system data collector cannot reliably run in an environment with non-readable secondaries. To use query statistics system data collector, set all secondary availability group replicas to allow read-access.

Features that Do Not Interoperate with Always On Availability Groups

[!INCLUDEssHADR] does not interoperate with the following features:

• Database mirroring. For more information, see Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server).

Related Content

• Blogs:

  Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments SQL Server Always On Team Blogs: The official SQL Server Always On Team Blog CSS SQL Server Engineers Blogs

• Whitepapers:

  Migration Guide: Migrating to Always On Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery Microsoft White Papers for SQL Server 2012 SQL Server Customer Advisory Team Whitepapers

See Also

Overview of Always On Availability Groups (SQL Server) Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)