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 |
|---|---|
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. |
See Also
Concepts
Database Mirroring and Backup and Restore