Muokkaa

Jaa


Always On availability groups: interoperability (SQL Server)

Applies to: SQL Server

This article documents interoperability of Always On availability groups with other SQL Server features.

Features that Interoperate with Always On availability groups

The following table lists SQL Server features that interoperate with Always On availability groups. 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 don't interoperate with Always On availability groups

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