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



Always On AG is Down when service is stopped

Updated October 04, 2016 09:02 AM

High Availability Options For SQL Server

Updated May 11, 2017 16:06 PM

SQL Server AlwaysOn FCI vs AG Doubts

Updated June 30, 2017 21:06 PM