Issue with Data Synchronization in Always On Setup

• RK2012

  SSC Eights!

  Points: 960

  More actions

  September 4, 2024 at 6:47 pm

  #4454074

  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

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  September 5, 2024 at 7:10 pm

  #4454419

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.