Database Mirroring Operating Modes

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

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.

Community Additions