AlwaysOn Replicas set to manual but failing automatically

by Matt Davis   Last Updated March 14, 2019 19:06 PM

My two synchronous-commit SQL AO replicas are set for manual failover mode but are failing over automatically. When I look through the logs and extended events, it looks just like what would happen if it were set automatically. This was set before a time when I was out of this office and the servers have been rebooted multiple times for updates, so I know the service account isn't waiting for a restart. Manual failover works but unsure why automatic is happening. There were 4 nodes, but the 2 remote DR nodes are currently removed both from SQL AOAG and WSFC. Any advice on where to look to figure this out?



Related Questions


Updated January 21, 2018 04:06 AM

Updated October 04, 2016 09:02 AM

Updated May 11, 2017 16:06 PM

Updated June 30, 2017 21:06 PM

Updated November 26, 2017 14:06 PM