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