Jaa


Database Mirroring and Other Features and Components

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.

In This Section

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.

See Also

Concepts

Database Mirroring and Backup and Restore

Help and Information

Getting SQL Server 2005 Assistance