Hello Team,
We have a 2-node Always On setup(SQL2017), where the primary node is in synchronous mode, and the secondary node is in asynchronous mode. Yesterday, the customer reported that certain tables were not synchronizing between the primary and secondary databases.
Upon investigation, I found that the synchronization between the primary and secondary databases had stopped for a specific database. I attempted to resume data movement from the primary node, but this did not resolve the issue.
I did not encounter any error messages during my checks, which makes the situation unclear. I’m looking into this further, but any additional insights or suggestions would be greatly appreciated