http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/10/24/sql-server-service-broker-error-database-cannot-be-enabled/

Printed 2014/10/24 05:25PM

SQL Server Service Broker error database cannot be enabled

By Basit Aalishan Masood-Al-Farooq, 2012/10/24

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.

Msg 9772, Level 16, State 1, Line 1 
The Service Broker in database “DatabaseName” cannot be enabled because there is already an enabled Service Broker with the same ID. 
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

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.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.