Always On Availability Groups: Interoperability (SQL Server)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic documents interoperability of Always On availability groups with other SQL Server features in SQL Server 2016.

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 2016. 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 Always On availability groups with specific restrictions. See the linked topics for details.

Features that Do Not Interoperate with Always On Availability Groups

Always On availability groups does not interoperate with the following features:

See Also

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