Tag Archives: example of Automatic Failover in SQL Server Mirroring

SQL Server Mirroring Automatic Failover

What is Automatic Failover in SQL Server Mirroring? When the principal server is offline, the mirror and the witness will form a quorum and promote the mirror to be the principal. Once this is done users can continue work as usual on the other server (New Principal Server) An automatic failover causes the mirror server [...]