Database Broker is Disabled

Description

After you manually restore the Sequence database, you receive the following error message in runtime (and in the event log).

Exception information:
Exception type: InvalidOperationException
Exception message: ExSqlDatabaseBrokerDisabled

Cause

The broker for the database is disabled.

Affected Versions

All versions

Solution

Enable the database broker using the following SQL query:

ALTER DATABASE SEQUENCE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

NOTE: If you restore from one Sequence database to another, you might receive an error message explaining that the broker service could not be enabled because there is already an enabled Service Broker with the same ID. In that case, create a new database broker by using the following SQL query.
ALTER DATABASE SEQUENCE SET NEW_BROKER WITH ROLLBACK IMMEDIATE