High Availability: Interoperability and Coexistence

Community Content

In this section

Statistics Annotations (0)

Collapse All

SQL Server 2008 Books Online (October 2009)

High Availability: Interoperability and Coexistence

Database mirroring can be used with the following features or components of SQL Server:

Log shipping can be used with the following features or components of SQL Server:

Note:
For a general comparison of the SQL Server high-availability solutions, see High Availability Solutions Overview.

In This Section

Database Mirroring and Failover Clustering: Describes database mirroring as an easy-to-manage alternative to failover clustering. Database mirroring can be used between two different failover clusters, but not within a single cluster.

Database Mirroring and Log Shipping: Describes how a single database can be configured as the principal database in a mirroring session and also as the primary database in a log shipping configuration.

Database Mirroring and Cross-Database Transactions: Describes why database mirroring is not supported with either cross-database transactions or distributed transactions.

Database Mirroring and Full-Text Catalogs: Describes how to mirror a database that has a full-text catalog.

Database Mirroring and Database Snapshots: Describes how to create one or more database snapshots on a mirror database to permit clients to use the mirror database for limited report writing.

Replication and Database Mirroring: Describes the effects of log shipping on replication behavior and the requirements and procedures for replicating from the secondary if the primary is lost.

Replication and Log Shipping.: Describes the effects of log shipping on replication behavior and the requirements and procedures for replicating from the secondary if the primary is lost.