Technical Track

Fixing could not start service broker for database

1 min read

Jun 28, 2018

Blogging is something I love because it gives me a chance to share the ideas I have and the knowledge I have gained so far. Last week, one of our clients was doing some maintenance activity. Today's blog post comes from that maintenance activity. Our monitoring tool Avail quickly identified an issue and reported it back to us. The error was Could not start Service Broker for database. The issue was that the database was a restored copy on the same server. The database has a service broker enabled already. Whenever a database with a service broker is restored, you will notice an error message written into the SQL Server Error log which says something like Could not start Service Broker for database id. Fixing this issue is very easy. All you need to do is execute an ALTER Database command. In this blog post, I will tell you what that command is.

Fixing the service broker issue

To fix the issue, one has to create a new service broker using the command and it will fix the issue for the service broker.

ALTER DATABASE DBName SET NEW_BROKER

There is another error you may observe that is related to the service broker. It reads: Service Broker GUID does not match the one in sys.databases. This is because the master database keeps track of the service broker for the database that has service broker enabled on it. To fix this issue, execute the same command I mentioned above and it will fix the issue. You may want to visit our resources page or technical track of our blog site to explore of our technical content, and if you need any assistance or professional help, please visit our expert’s page and we will certainly be able to help you.

← Hugepages support for Oracle RDS

An Oracle "oraenv" script solution for Windows with PowerShell →

Get Email Notifications

No Comments Yet

Let us know what you think

Fixing could not start service broker for database

Fixing the service broker issue

Share this

You May Also Like

Import/export multiple SSIS packages

How to fix error when MySQL client fails to load SQL file with Blob data

EBS DBA: R12.1.2 Another Step for Automated Vanilla EBS Cloning

Get Email Notifications

No Comments Yet