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)
精彩评论