October 29, 2014 at 12:32 am
Good Morning to all,
I'm Mr.Tuyen from VietNam. I have a big problem with AlwaysOn High Availabity in SQL 2012.
I setup 3 server and join Availabilty Group. Ex: Server A (Primary), Server B (Secondary), Cluster Qourum is only node. I have test:
1. Stop service SQL server A, immediately server B is Primary
Start servicel SQL server A, Server A is secondary
2. Stop service SQL server B, server is not Primary and "status is Resloving" and role cluster failed with error as belows
Clustered role 'XXX' has exceeded its failover threshold. It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state. No additional attempts will be made to bring the role online or fail it over to another node in the cluster. Please check the events associated with the failure. After the issues causing the failure are resolved the role can be brought online manually or the cluster may attempt to bring it online again after the restart delay period.[/i]
or
The Cluster service failed to bring clustered role 'XXX' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered role.
Do you have same error?
October 29, 2014 at 1:08 am
This is not an error it is default cluster resource Failover policy behaviour.
Open the properties for the alwayson cluster resource and change the default from 1 failure in 6 hours to your desired setting.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2014 at 1:54 am
Dear men,
Tks for your reply. I have try to setup follow this your instruction but no success. Do have a some away?
October 29, 2014 at 3:00 am
Please detail exactly what you have done so far, maybe supply a screenshot
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2014 at 4:00 am
Dear man,
This is a screen shot when i test
1. Cluster Running OK
https://onedrive.live.com/redir?resid=C17BAF7802F7D230%212077
2. Cluster failed when i stop service SQL of Primary Node
https://onedrive.live.com/?cid=C17BAF7802F7D230&id=C17BAF7802F7D230%212075&v=3
3. Config Cluster Resoure
https://onedrive.live.com/redir?resid=C17BAF7802F7D230%212076
October 29, 2014 at 4:54 am
have you checked the cluster events and the windows event logs for detail of the resource failure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2014 at 7:01 am
Can you expand under "Other Resources", I believe there should not be anything expandable, but only one entry. The only resource in your cluster is the availability group, right? Also, have you looked at the dashboard for your availability group?
Jared
CE - Microsoft
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply