zedtec (3/19/2014)
Hi Perry,No confusion.....Failover is performed at the principal server isn't it?
No, not when the principal is dead as you quoted in your scenario above. In this case you would use the following from the mirror to bring the mirror database online
ALTER DATABASE [somehadb] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
zedtec (3/19/2014)
If the principal is down then how would failover take place?That was my question in a nutshell.
see above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉