Service Broker not working after database restore
Posted
by roryok
on Stack Overflow
See other posts from Stack Overflow
or by roryok
Published on 2010-05-28T12:15:29Z
Indexed on
2010/05/28
15:42 UTC
Read the original article
Hit count: 224
sql-server
|service-broker
Have a working Service Broker set up on a server, we're in the process of moving to a new server but I can't seem to get Service Broker set up on the new box.
Have done the obvious (to me) things like Enabling Broker on the DB, dropping the route, services, contract, queues and even message type and re adding them, setting ALTER QUEUE with STATUS ON
SELECT * FROM sys.service_queues
gives me a list of the queues, including my own two, which show as activation_enabled, receive_enabled etc.
Needless to say the queues aren't working. When I drop messages into them nothing goes in and nothing comes out.
Any ideas? I'm sure there's something really obvious I've missed...
© Stack Overflow or respective owner