AlwaysOn Availability Groups: Interoperability (SQL Server)
This topic documents interoperability of AlwaysOn Availability Groups with other SQL Server features in SQL Server 2016.
In This Topic:
The following table lists SQL Server features that interoperate with AlwaysOn Availability Groups in SQL Server 2016. A link in the More Information column indicates that interoperability considerations exist for a given feature.
Change data capture
FILESTREAM and FileTable
Remote Blob Store (RBS)
Utilize read only secondary replicas as a reporting data source and reduce the load on your primary read-write replica.
SQL Server Agent
The following features interoperate with AlwaysOn Availability Groups with specific restrictions. See the linked topics for details.
Cross-database transactions/distributed transactions (SQL Server 2016 Community Technology Preview 2 (CTP2) and Windows Server 2016 Technical Preview 2). For more information, see Cross-Database Transactions Support For Database Mirroring or AlwaysOn Availability Groups (SQL Server)
AlwaysOn Availability Groups does not interoperate with the following features:
Database mirroring. For more information, see Cross-Database Transactions Support For Database Mirroring or AlwaysOn Availability Groups (SQL Server).