Fixing could not start Service Broker for database

Posted in: Microsoft SQL Server, Technical Track

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.

 

email

Interested in working with Hemantgiri? Schedule a tech call.

About the Author

Data Platform Consultant
I am a Database Administrator by profession, and a student at a university called life by heart. I am passionate about SQL Server, photography, reading and sharing. Currently, I'm Data Platform Consultant @Pythian. I have been a Microsoft SQL Server MVP for four years, and a published author of the book - SQL Server 2008 High Availability. Keep in touch with me on twitter @hemantgirig

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *