Problem

The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the same SQL Server instance with a different database name and the T-SQL command (ALTER DATABASE ‘DatabaseName’ SET ENABLE_BROKER) is issued to enable the Service Broker for this restored database.

Solution

Checkout my article (ie. SQL Server Service Broker error database cannot be enabled) in which I discussed how you can fix this error message. This article is published on MSSQLTips.com.