Always On availability groups: interoperability (SQL Server)
This topic documents interoperability of Always On availability groups with other SQL Server features in SQL Server 2017.
Features that Interoperate with Always On Availability Groups
The following table lists SQL Server features that interoperate with Always On availability groups in SQL Server 2017. A link in the More Information column indicates that interoperability considerations exist for a given feature.
Features that Interoperate with Always On Availability Groups with Restrictions
The following features interoperate with Always On availability groups with specific restrictions. See the linked topics for details.
- Cross-database transactions/distributed transactions (SQL Server 2016 (13.x) and Windows Server 2016). 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
Always On availability groups 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).
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
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
Send feedback about: