Always On Availability Groups: Interoperability (SQL Server)

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

Features That Interoperate with AlwaysOn Availability Groups

The following table lists SQL Server features that interoperate with Always On Availability Groups in SQL Server 2014. 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 AlwaysOn Availability Groups (SQL Server)
Change tracking	Replication, Change Tracking, Change Data Capture, and AlwaysOn Availability Groups (SQL Server)
Contained databases	Contained Databases with AlwaysOn Availability Groups (SQL Server)
Database encryption	Encrypted Databases with AlwaysOn Availability Groups (SQL Server)
Database snapshots	Database Snapshots with AlwaysOn Availability Groups (SQL Server)
FILESTREAM and FileTable	FILESTREAM and FileTable with AlwaysOn Availability Groups (SQL Server)
Full-text search	Note: Full-Text indexes are synchronized with AlwaysOn secondary databases.
Log shipping	Prerequisites for Migrating from Log Shipping to AlwaysOn Availability Groups (SQL Server)
Remote Blob Store (RBS)	Remote Blob Store (RBS) and AlwaysOn Availability Groups (SQL Server)
ReplicationConfigure Replication for AlwaysOn Availability Groups (SQL Server) Maintaining an AlwaysOn Publication Database (SQL Server) Replication, Change Tracking, Change Data Capture, and AlwaysOn Availability Groups (SQL Server) Replication Subscribers and AlwaysOn Availability Groups (SQL Server)
Analysis Services	Analysis Services with AlwaysOn 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 AlwaysOn Availability Groups (SQL Server)
Service Broker	Service Broker with AlwaysOn Availability Groups (SQL Server)
SQL Server Agent

Features that Do Not Interoperate with AlwaysOn Availability Groups

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

• Cross-database transactions/distributed transactions

  For information about why such transactions are not supported, see Cross-Database Transactions Not Supported For Database Mirroring or AlwaysOn Availability Groups (SQL Server).

• Database mirroring

Related Content

• Blogs:

  Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

  SQL Server AlwaysOn Team Blogs: The official SQL Server AlwaysOn Team Blog

  CSS SQL Server Engineers Blogs

• Whitepapers:

  Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

  Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

  Microsoft White Papers for SQL Server 2012

  SQL Server Customer Advisory Team Whitepapers

See Also

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