CODEWITHSUNDEEP
sql-server-2005servicenotificationsservice-broker
Rishabh Ohri
Rishabh Ohri

Reputation: 1310

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?

Upvotes: 0

Views: 815

Answers (1)

Nix
Nix

Reputation: 58522

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)

Upvotes: 2

Related Questions