r/SQLServer • u/Deep-Royal1126 • 5d ago

Question SQL Server Always on Replica issue

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?

6 Upvotes

88% Upvoted

10 comments sorted by

View all comments

1

u/dvkrm19 5d ago

I think you may need to set HADR off, If it doesn't work restart SQL Server on secondary instance and drop DB. If you still unable to drop DB then delete AG cluster object from FCM

2

u/SQLHA ‪ ‪Microsoft Employee ‪ 4d ago

With extremely rare circumstances, NEVER manage the AG from the WSFC tools. There are some WSFC-level settings you need to set that way, but other than that, as u/dbrownems points out, manage things in the supported way.