After removing db from AG the secondary goes into Not Syncronizing

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  March 14, 2023 at 4:46 pm

  #4160659

  SQL Server 2019: So I have some databases that are no longer needed that were in an Availability group.  I removed them from the AG and the database goes into Not Syncronizing instead of restoring.  It was successfully removed from the primary and two of the secondaries but the third secondary it went into Not Syncronizing instead of restoring.  I try to drop it and I get this:

  The operation cannot be performed on database "xxxxxx" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

  ALTER DATABASE statement failed.

   

  Any idea on how to drop the db?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  March 15, 2023 at 5:10 pm

  #4161074

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

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

• March 15, 2023 at 5:44 pm

  This was removed by the editor as SPAM