开发者

Service Broker getting Automatically Disabled

开发者 https://www.devze.com 2023-01-08 22:27 出处:网络
As we know the Service Broker is enabled for the new databases we create. But recently the service broker 开发者_高级运维got disabled automatically. Even if the database was restored shouldnt the Serv

As we know the Service Broker is enabled for the new databases we create. But recently the service broker 开发者_高级运维got disabled automatically. Even if the database was restored shouldnt the Service Broker be enabled by default?


How did you do the restore? During the restore service broker is disabled by default.

Try doing

   RESTORE DATABASE <database_name>  FROM  <backup_device> with ENABLE_BROKER

THe above command is fully explained on MSDN RESTORE Arguments (Transact-SQL)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号