Database Mirroring Operating Modes

This section contains information about the synchronous and asynchronous operating modes for database mirroring sessions.

In This Section

• Asynchronous Database Mirroring (High-Performance Mode)
  Describes how asynchronous database mirroring works, when it is appropriate to use high-performance mode, and how to respond if the principal server fails.

• Synchronous Database Mirroring (High-Safety Mode)
  Discusses how synchronous database mirroring works, including the alternative high-safety modes (with automatic failover and without automatic failover), and contains information about the role of the witness in automatic failover.

• Transact-SQL Settings and Database Mirroring Operating Modes
  Describes a database mirroring session in terms of the ALTER DATABASE settings and states of the mirrored database and witness, if any.

See Also

Concepts

Database Mirroring Overview

Database Mirroring Sessions

Role Switching During a Database Mirroring Session

Other Resources

Database Mirroring Deployment

Database Mirroring Administration

Monitoring Database Mirroring