Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Links

Wiki
Blog

Forum Statistics

Users
Members:
1873
Members Online:
1
Guests Online:
78

Total Post History
Posts:
81445
Topics:
18714

7-Day Post History
New Posts:
0
New Topics:
0
Active Topics:
0

Our newest member
BitogClogs

Other

FAQ
All times are UTC [ DST ]

Google Ads

existing sql server AG fails handshaking after network outag

Please wait...

existing sql server AG fails handshaking after network outag

Postby rvanveen on Fri Aug 14, 2015 7:13 pm

Hi. I looked over the troubleshooting guide, and it's very helpful, but doesn't help my situation.

I'm running a primary and secondary on sql server 2012 enterprise edition on windows server 2012, and it runs fine except when a network outage occurs.

Then the handshaking keeps failing, and the only way to fix it is to reboot both primary and secondary.

keep getting 3520's, etc.

Was wondering if upgrading to windows server 2012r2 would help this, or does anyone have any suggestions on commands to try in future, to eliminate all these prod reboots?
Any suggestions would be highly appreciated. Thanks.

I increased query connection timeouts to 60, but saw no change.
rvanveen
Newbie
Newbie
 
Posts: 1
Joined: Fri Aug 14, 2015 7:08 pm
Unrated