March 16, 2023 at 3:15 pm
Hello experts,
I'm seeing a strange problem that I don't know how to permanently fix. For an AG that I administer, I am seeing that some - but not all - databases are inaccessible. The inaccessible databases show this message:
Policy Evaluation Result on Availability Database ...
Data synchronization state of availability database is not healthy
Description:
The data synchronization state of this availability database is unhealthy. On an asynchronous-commit availability replica, every availability database should be in the SYNCHRONIZING state. On a synchronous-commit replica, every availability database should be in the SYNCHRONIZED state.
And when I expand the AG databases, I see a mix of accessible and inaccessible databases (see screenshot).
I managed a clumsy fix yesterday by restarting the primary node for that AG. It was OK for a while, but the users soon reported that the same situation had returned about 30 min later.
Does anyone know why this condition arises, and how I can investigate and fix it?
Thanks for any help!
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 16, 2023 at 7:14 pm
If your databases stop synchronizing - then you have additional issues with those databases. You need to figure out why those databases have stopped synchronizing and address those issues.
Look into the SQL Server logs on the primary and secondary - and the windows event logs to see if there are any other messages that can help identify why you are having these issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 16, 2023 at 8:09 pm
Hi Jeffrey,
Great, thanks for your help. I'll check the logs to see what is different between the two subsets of databases that could be causing this issue.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 14, 2023 at 9:47 pm
Is the group set synchronous or asynchronous mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply