ALWAYS ON SQL DATABASE ISSUE

Question

Hello Everybody,

          We have SQL 2016 ENT running on Windows 2016 Standard in our Head Office (Primary Site) and DR  (Secondary Site). Recently we have implemented the ALWAYS ON AVAILABILITY GROUP. There are several databases which are not synchronizing (No Firewall in Between) the branch's, latency is 60 ms. To make more sure I have created a dummy database on the primary which is merely 16 MB and its not synchronizing , please check the screenshot and let me know how it can be resolved. I come from network side so please don't expect much from SQL side but I will make sure if you guide me in proper way I will resolve the case.  

Answer 1

Hi @skak

Actually, we just see your screenshot and only answer based on these...

From what I can see, everything is working fine except your testdb and here the message clearly says "secondary database is not joined"

Please share a full screenshot of the Avail. Group Dashboard with us, so that we can see more details about the status.

And have you already worked through the SQL Server AG troubleshooting guide?
https://learn.microsoft.com/en-us/troubleshoot/sql/availability-groups/troubleshooting-alwayson-issues

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

Hi @skak ,

Please refer to this document:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/secondary-database-is-not-joined?view=sql-server-ver16

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.