开发者

Service Broker getting Automatically Disabled

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜