Service Broker in the database cannot be enabled because a service broker with the same ID is enabled.

Scenario:

For MySQL database, if the name is db1, the service broker is enabled, db1 is backed up, and then restored to DB2 (that is, DB2 is a full backup image of db1), and then used

Use master
Alter database DB2 set enable_broker

The following error occurs when you want to enable the broker:

Service Broker in Database "DB2" cannot be enabled because a service broker with the same ID is enabled.

Solution:

Use master
Alter database DB2 set new_broker

Then run

Use master
Alter database DB2 set enable_broker

-- Verify whether the feature can be enabled
Go
Select databasepropertyex ('db2 ', 'isbrokerenabled ')

OK!