Tag Archives: db mirroring

How can I bring mirror database online after principal server is down ?

Safety FULL with Witness :

Well the answer for this ‘depends on the mode in which mirroring is configured’. If mirroring is configured in High Availability mode (Full safety) then we don’t need to worry about failover as the mirror server will form a quorum with witness and will initiate an automatic failover. The safety level can be set using the below command,

Continue reading How can I bring mirror database online after principal server is down ?