1 out of 1 rated this helpful - Rate this topic

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.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions