1 out of 1 rated this helpful - Rate this topic

Database Mirroring Operating Modes

SQL Server 2008

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions