Share via


AlwaysOn Availability Groups: Interoperability (SQL Server)

This topic documents interoperability of AlwaysOn Availability Groups with other SQL Server features in SQL Server 2012.

In This Topic:

  • Features That Interoperate with AlwaysOn Availability Groups

  • Features that Do Not Interoperate with AlwaysOn Availability Groups

  • Related Content

Features That Interoperate with AlwaysOn Availability Groups

The following table lists SQL Server features that interoperate with AlwaysOn Availability Groups in SQL Server 2012. 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)

Replication

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

Arrow icon used with Back to Top link[Top]

Features that Do Not Interoperate with AlwaysOn Availability Groups

AlwaysOn Availability Groups does not interoperate with the following features:

Arrow icon used with Back to Top link[Top]

Arrow icon used with Back to Top link[Top]

See Also

Concepts

Overview of AlwaysOn Availability Groups (SQL Server)

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