Availability Group Issue - Removed from primary and secondary stucking in resolving

Question

I have an availability group that was removed on the primary server.  The secondary server has this availability in a resolving state.

When I try to drop the availability group I get cannot drop the availability group 'Name', because it does not exist or you do not have permission (I am an admin).

I try to remove the database by issuing:

ALTER DATABASE [DATABASE NAME] SET HADR OFF 

And I get: The availability group 'group guid' and/or its local availability replica does not exist.  Verify that the specified availability group name is correct, and that the local availability replica has joined the availability group, then retry the operation.

How do I resolve this?

Answer 1

Can anyone help with this?  I am unable to remove the availability group from the server nor am I able to do anything with the databases within this availability group.

Answer 2

Restart of the SQL Service solved the issue.  

Answer 3

Hi,

Thanks for sharing with us.

---

Ray Chen

TechNet Community Support