TechNet
Export (0) Print
Expand All

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:

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 captureReplication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)
Change trackingReplication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)
Contained databasesContained Databases with Always On Availability Groups (SQL Server)
Database encryptionEncrypted Databases with Always On Availability Groups (SQL Server)
Database snapshotsDatabase Snapshots with Always On Availability Groups (SQL Server)
FILESTREAM and FileTableFILESTREAM and FileTable with Always On Availability Groups (SQL Server)
Full-text searchNote: Full-Text indexes are synchronized with Always On secondary databases.
Log shippingPrerequisites 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)
ReplicationConfigure 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 ServicesAnalysis 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 BrokerService 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)

Community Additions

ADD
Show:
© 2016 Microsoft