December 24, 2014 at 6:16 am
Recently after turning on trace I restarted the sql services on a box which is configured for automatic failover availability groups. The ag has not failed over to other node. The other node was in resolving state. When the restarted server is back, the AG went back to that server. I checked the sys.availability groups field for failover property failure condition level, it's set to 1 which means service restarts should initiate the failover. Why I am observing this behavior? Any suggestion? What's the best setting?
December 25, 2014 at 3:42 am
both replicas must be configured for synch mode and automatic failover, check the AO group properties
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2014 at 11:13 pm
The following article about SQL 2012 AlwaysOn Availability groups Automatic Failover doesn’t occur or does it may be helpful to troubleshoot this issue:
December 28, 2014 at 4:47 am
Thanks Shadow and Perry.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply