Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Database Mirroring Operating Modes

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

© 2015 Microsoft