July 5, 2016 at 5:12 am
I have implemented an AlwaysOn AG and configured it for synchronous replication and automatic failover but I find that when I stop the SQL Instance on the primary using SQL Server Configuration manager, the AG instance role does not automatically start on the secondary. What am I doing wrong?
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
July 5, 2016 at 8:14 am
Br. Kenneth Igiri (7/5/2016)the AG instance role does not automatically start on the secondary.
So you have two SQL instances with at least one Availability Group on there? Can you do a controlled failover successfully from SSMS?
How many nodes are there in your failover cluster (i.e. do you have a fileshare witness or something like that to make a third node?).
July 5, 2016 at 3:05 pm
Beatrix Kiddo (7/5/2016)
Br. Kenneth Igiri (7/5/2016)the AG instance role does not automatically start on the secondary.
So you have two SQL instances with at least one Availability Group on there? Can you do a controlled failover successfully from SSMS?
How many nodes are there in your failover cluster (i.e. do you have a fileshare witness or something like that to make a third node?).
There are two nodes in the cluster and one file share witness. And YES I can do a controlled failover successfuly. Works perfectly. But when I termintae SQL server service, the AG goes to failed mode on the cluster.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
July 7, 2016 at 12:29 am
Thanks all. I eventually solved this by setting the Maximum Failures in the specified period for the Cluster Role which has the same name as my Availability Group to a very high value. I want to believe this is the case simply because I was testing.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply