Enabling Service Broker in Availability Group

• swissmawi

  SSC Enthusiast

  Points: 176

  More actions

  October 4, 2019 at 2:28 pm

  #3686053

  We need to enable Service Broker in a database which is part of an availability group. Generally I am finding information that one should enable Service Broker first, then create the AVG. But now we have a productive system already in an AVG with 3 partners. What is the best practise to enable Service Broker (ALTER DATABASE ENABLE BROKER) in an AVG?

  Best regards, Martin

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 5, 2019 at 3:10 pm

  #3686250

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• john.deprato

  Old Hand

  Points: 360

  More actions

  February 4, 2020 at 11:23 pm

  #3723130

  It can only be enabled before the database is added to the AG.