Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Database Mirroring and Other Features and Components

SQL Server 2005

Updated: 5 December 2005

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

  • Failover clustering
  • Log shipping
  • Full-text catalogs
  • Database snapshots
  • Replication
  • Notification Services

For a general comparison of the SQL Server high-availability solutions, see Configuring High Availability.

Topic Description

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 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

Using Log Shipping or Database Mirroring with Notification Services

Describes recommendations for configuring the mirror server, which is only a warm standby server when used with Notification Services.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.