Thursday, November 08, 2012 4:08 PM
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?
Monday, November 12, 2012 2:23 AMCan 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.
Sunday, November 18, 2012 4:27 AMRestart of the SQL Service solved the issue.
- Marked As Answer by dbjadams Sunday, November 18, 2012 4:27 AM
Monday, November 19, 2012 8:59 AMModerator