SQL Server – Msg 1468, Level 16, State 1, Line 1

ERROR

Msg 1468, Level 16, State 1, Line 1

The operation cannot be performed on database "DBName" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Below are the steps I did to resolve the error.

• Remove DBName from AAG

• Enable Service Broker

ALTER​​ DATABASE​​ DBName​​ SET​​ ENABLE_BROKER;

• Verify Service Broker Enabled

SELECT​​ is_broker_enabled​​ FROM​​ sys.databases​​ WHERE​​ name​​ =​​ 'DBName';

• Add DBName to AAG