The SQL Server Service Broker for the current database was not enabled

To restore one data to another server, an exception occurred:

the SQL Server Service Broker for the current database was not enabled, and as a result query notifications be not SUP  Ported. Please enable the Service Broker for this database if you wish to use notifications.

As follows:

Workaround:

Refer to the above steps, which can be set to true.
However, you may not be so successful when you click on the "OK" button, another exception is present:

How to solve it? No relationship, you can execute SQL statements in SQL Query Analyzer:

DECLARE @DBNameSYSNAMESET @DBName = 'Tutorial'  --' Your DB Name 'DECLARE @spid INTSELECT @spid = MIN(SPID) from [MASTER].[dbo].[sysprocesses] WHEREdbid= db_id(@DBName) while @spid  is  not NULLBEGIN    EXECUTE('KILL' + @spid)    SELECT @spid = MIN(SPID) from [MASTER].[dbo].[sysprocesses] WHEREdbid= db_id(@DBName) andspid> @spidENDEXECUTE('ALTER DATABASE'+ @DBName +'SET Enable_broker')--Disable_broker

Source Code

The SQL Server Service Broker for the current database was not enabled