Skip to main content
TechNet
Always On Availability Groups: Interoperability (SQL Server)
 

Published: May 17, 2016

Updated: May 17, 2016

Applies To: SQL Server 2016

This topic documents interoperability of Always On Availability Groups with other SQL Server features in SQL Server 2016.

In This Topic:

  • Features That Interoperate with Always On Availability Groups

  • Features that Interoperate with Always On Availability Groups with Restrictions

  • Features that Do Not Interoperate with Always On Availability Groups

  • Related Content

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.

FeatureMore 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 searchNote: 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 ServicesUtilize 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

The following features interoperate with Always On Availability Groups with specific restrictions. See the linked topics for details.

Always On Availability Groups does not interoperate with the following features:

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