Tag Archives: What SQL Server Does when we manually initiate a failover

How to perform SQL Server Mirroring Manual Failover?

What is SQL Server Mirroring Failover ? When the principal server is offline, the mirror and the witness will form a quorum and promote the mirror to be the principal. This is known as Mirroring Failover. Failover can be either automatic or manual. Automatic Failover: If the principal server fails in High Availability mode, failover [...]