March 2, 2011 at 7:37 am
after a restore service broker fails. I can reset it using enable_broker or new_broker option. Is there any reason for me to use new_broker over enable_broker if restore is on a different server?
thoughts?
March 2, 2011 at 2:29 pm
This is from MSDN and may help:
ENABLE_BROKER. This option activates Service Broker message delivery, preserving the existing Service Broker identifier for the database.
NEW_BROKER. This option activates Service Broker message delivery and creates a new Service Broker identifier for the database. This option ends all existing conversations in the database, and returns an error for each conversation. This is because these conversations do not use the new identifier. Any route that references the old Service Broker identifier must be re-created with the new identifier.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply