Skip to main content

What is Database Mirroring? Why is it deprecated?

Mid MS SQL
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.

Answer

Mirroring uses principal + mirror + witness for automatic failover. Deprecated in favor of Availability Groups.

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.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice