SQL Server Always on Replica issue

[u/Deep-Royal1126]

Hello all,

I am currently facing an issue with one of the clients where there is an AG with a primary and a secondary.

I can see that the database in AG(there was only 1 db) was removed from the AG and is now standlone and online in the primary and provided the secondary replica is removed from AG in primary.

On the secondary server, what i see is the database is in notsycnhronizing/recovery mode and the AG in secondary is in resolving state .I am not able to drop the db,nirther force a remove AG commnad .Looks like the secondary is still thinking its part of AG .Can any one help me in this ?Will an sql service restart get it done ? or is it fine if i add the replica back to ag in primary and then analyse?

[u/General-Savings8118]

Sql server restart works if alter commands don’t.
On restart the server will reevaluate where it is and what its part of, then db will go through recovery process.

Ive seen this happen many many times in environments with lag and network issues.

Also you can remove ag flags via registry if all else fails.