Post reply

Sql Server Service Broker

  • November 25, 2015 at 1:55 am

    #309830

    Hi all, what can disable the service broker?

    if you explicitly disable it ==> Yes

    if you restore the database ==> yes

    if you detach or attach the database ==> ?

    What else?

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • November 26, 2015 at 8:15 am

    #1842517

    I've downgraded an instance from Ent to Std and it broke the broker so to speak, so had to re-set\re-enable it.

  • November 27, 2015 at 12:05 am

    #1842572

    thanks for the info Simon 😉

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

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

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