This topic has not yet been rated - Rate this topic

AlwaysOn Availability Groups: Interoperability (SQL Server)

SQL Server 2012

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:

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

Arrow icon used with Back to Top link [Top]

Concepts

Overview of AlwaysOn Availability Groups (SQL Server)

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD