After you manually restore the Sequence database, you receive the following error message in runtime (and in the event log).
Exception information:Exception type: InvalidOperationExceptionException message: ExSqlDatabaseBrokerDisabled
The broker for the database is disabled.
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