In AWS RDS MSSQL we have mirroring running between primary and replica via Always On. We want to remove/drop a couple of databases, but when we try:
ALTER AVAILABILITY GROUP RDSAG0 REMOVE DATABASE [db-name]
we receive the error:
Msg 15151, Level 16, State 1, Line 27 Cannot alter the availability group 'RDSAG0', because it does not exist or you do not have permission.
Any advice is greatly appreciated