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.
| Topic | Description |
|---|---|
|
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. | |
|
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. | |
|
Describes how to mirror a database that has a full-text catalog. | |
|
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. | |
|
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. |
