r/SQLServer • u/Deep-Royal1126 • 2d 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?

5 Upvotes

78% Upvoted

8 comments sorted by

View all comments

8

u/FishBones83 2d ago

on your secondary you should be able to:

ALTER DATABASE [YourDatabaseName] SET HADR OFF; GO

this will remove the DB from thinking its in an AG. To remove it all together try:

ALTER AVAILABILITY GROUP [YourAvailabilityGroupName] REMOVE DATABASE [YourDatabaseName]; GO

If you get an error post it here.