Answer
Mirroring uses principal + mirror + witness for automatic failover. Deprecated in favor of Availability Groups.
Quick Answer
Database Mirroring sends transaction log blocks from principal to mirror in real-time. High-Safety mode (synchronous) = automatic failover with a witness. High-Performance mode (asynchronous) = potential data loss. Deprecated since SQL Server 2012 in favor of AlwaysOn AGs, which are more flexible and feature-rich.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ