1

After we tried configure a database with service broker into an always on environment and failed (the service broker is not working properly) we are now considering to try mirroring for high availability.

The client demands it'll use automatic failover which i know needs a witness server. i have configured mirroring many times before but never with service broker. Has anyone tried and it worked? I tried to find an official documentation for it but didn't find anything. What are the steps to configure it on the mirrored database? will it cause performance issues to use service broker with mirroring which is also synchronized?

Improve this question
0

1 Answer 1

Reset to default
0

There is nothing special about configuring Service Broker to work with mirroring. Configure Service Broker, then enable mirroring.

Having said that, you'll need to test failover to ensure any clients accessing the Service Broker infrastructure, such as queues, are able to failover gracefully from primary to secondary.

I'd recommend building a test-network using Virtual Machines including a primary, a secondary, and a witness VM. Restore a copy of the target database into the primary, and configure mirroring to see how it works.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.