Enabling broker after Restoring Sql Server DataBase
keep a note of these options ALTER DATABASE mydb SET ENABLE_BROKER ALTER DATABASE mydb SET DISABLE_BROKER ALTER DATABASE mydb SET NEW_BROKER if youre getting something like this is already an enabled Service Broker with the same ID, go for the NEW_BROKER