July 30, 2018 at 10:31 am
Hello,I just set up at a client a HADR cluster has two nodes.everything has been created,
I perform various tests and realize that when I simulate a crash (outage) on the primary, the switch to the secondary is not done and my bases are inaccessible.is this normal?
where is the high available in this case?
What's more in this configuration, my listener is no longer accessible eitherI am in synchronous validation mode and automatic failover.
Have I missed a setting?
thank you for your feedback.
July 30, 2018 at 10:48 am
joujousagem2006 1602 - Monday, July 30, 2018 10:31 AMHello,I just set up at a client a HADR cluster has two nodes.everything has been created,
I perform various tests and realize that when I simulate a crash (outage) on the primary, the switch to the secondary is not done and my bases are inaccessible.is this normal?
where is the high available in this case?
What's more in this configuration, my listener is no longer accessible eitherI am in synchronous validation mode and automatic failover.
Have I missed a setting?
thank you for your feedback.
You simply have not provided enough information to provide any kind of answers to your issues.
What type of HADR cluster? This is somewhat vague. Is this clustering, and availability group, or something else?
Have you missed a setting? Sounds like you have missed quite a few settings.
If you are attempting to set up an availability group, then this series of articles is a must-read
http://www.sqlservercentral.com/stairway/112556/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 30, 2018 at 10:49 am
Was the Listener Online when you tried making a connection? What is the Quorum configuration?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply