Wednesday, March 21, 2012

Msg 9772 -- Service Broker in database "" cannot be enabled

I backed up a database "Broker", and restored it on the same instance as "BrokerQA" (Broker db still exists, I need them both running on the same instance).

tried sending a few messages, sys.transmissions_queue says: The broker is disabled in the sender's database.

then tried to enable service broker for BrokerQA:

alter database BrokerQA set enable_broker

Msg 9772, Level 16, State 1, Line 2

The Service Broker in database "BrokerQA" cannot be enabled because there is already an enabled Service Broker with the same ID.

Msg 5069, Level 16, State 1, Line 2

ALTER DATABASE statement failed.


How do I reset the service broker ID on the newly restored database?
Thanks!eh, not being lazy does wonders....

alter database viagogoQA set NEW_BROKER

does the trick...

No comments:

Post a Comment