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: 223

Filed under:
|

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

Related posts about sql-server

Related posts about service-broker