Post reply

Service Broker and Mirroring

  • June 27, 2017 at 5:51 pm

    #402221

    Hi Guys

    I have been asked to break mirroring and disable service broker
    following which re-enable mirroring

    Has anyone done this ?
    is this possible ?

    Thanks

  • June 27, 2017 at 6:24 pm

    #1948471

    Alzashti - Tuesday, June 27, 2017 5:51 PM

    Hi Guys

    I have been asked to break mirroring and disable service broker
    following which re-enable mirroring

    Has anyone done this ?
    is this possible ?

    Thanks

    Yes but you can't re-enable mirroring - like using partner suspend and resume. You have to rebuild it from scratch.
    So set partner off to break the mirror and then set broker disable_broker and then rebuild the mirroring.

    Sue

  • June 27, 2017 at 6:58 pm

    #1948477

    Thanks Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply