Secondary database stuck in Not Synchronizing state

• webrunner

  SSC-Dedicated

  Points: 31882

  More actions

  July 12, 2022 at 7:46 pm

  #4062346

  Hello experts,

  I am trying to restore a database that is part of an Always On availability group. As usual, I started by removing the database in question from its availability group.

  One secondary database properly went into the Restoring... state and I was able to delete it. For some reason, however, this time around the other secondary database did not go into the Restoring... state. It has been stuck in the Not Synchronizing state for tens of minutes now.

  I can't take the database offline. I can't add the primary database back because the Not Synchronizing database still exists.

  Does anyone know how I can resolve this issue? Thanks for any help.

  -- webrunner

  • This topic was modified 2 years, 5 months ago by  webrunner.
  • This topic was modified 2 years, 5 months ago by  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

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  July 13, 2022 at 8:10 pm

  #4062948

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

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

• July 15, 2022 at 6:27 am

  This was removed by the editor as SPAM

• July 30, 2022 at 6:35 am

  This was removed by the editor as SPAM