• devanandiiway (3/14/2012)


    My question is do we have to disable the service broker by issuing the command alter database msdb set disable_broker.

    No. I have moved msdb with no problem without disbaling and enabling broker before and after the move. The only time I think you need to worry about that is if you're rebuilding and instance from a backup where you are not also restoring master as well.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato