question

FlorianPrestifilippo-8004 avatar image
0 Votes"
FlorianPrestifilippo-8004 asked SeeyaXi-msft commented

Secondary replica in SQL Availability Group is DISCONNECTED

Hi everyone,

I'm currently setting up a new database environment at work.
We have two SQL 2016 servers across our infrastructure that needs to be setted up with Availability Groups.
I read and followed several tutorials but I'm facing an issue that I can't solved.

I have a Windows Failover Cluster that's running fine, no error and so on.
I then have created an Availability Group between my SQL servers and everything went fine too.
All the check during the configuration went perfectly and the Availablity Group has been created.
But here comes the thing, when I check on my availability replicas, it says that my secondary replica is in critical state with several warning/errors messages and so the databases aren't replicating. When I check these messages, it says that my secondary replica is not connected to my primary one, the connected state is DISCONNECTED.

134672-capture.png

But I can't figure out why, I allowed everything necessary in our firewall, and I can't see anything denied between the two servers.
Thus, during the creation of the availability group, the servers can perfectly join each others and I can see that the group has been created on both servers...
It's the first time I'm working with availability groups so maybe I missed something somewhere, but nothing that has been mentionned on the different tutorial I've read.

Thanks !

sql-server-generalwindows-server-clustering
capture.png (13.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FlorianPrestifilippo-8004 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello FlorianPrestifilippo,

Have you tried the reasons and approach from the next Microsoft article?

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-replica-is-disconnected?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

Hi @FlorianPrestifilippo-8004,

Please refer to this link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/data-synchronization-state-of-some-availability-database-is-not-healthy?view=sql-server-ver15
Can you provide more error information?
For example, error log(Path or UI in SSMS), Windows events(See the picture).
134826-2.png
Error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG .
This will be helpful to solve the problem.

Here is the possible solution: https://basitaalishan.com/tag/availability-groups-database-state-not-synchronizing/

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


2.png (22.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.