How long to enable service broker

United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Service Broker. Sign in to vote. Wednesday, December 21, PM. Service Broker can be really confusing and causes data professionals to shy away from using it. One example is setting up SSB. It's easy, until you need to make a copy of your database. Then the fun begins. Do you think Service Broker is confusing?

Today we are going to cover what happens when you restore a database that contains Service Broker objects. First, let's cover what the GUID is for. This is easy to prove. I have a repro script that you can download and try for yourself. Or you can just follow along with the screenshots. We take a backup and restore it on the same instance as a copy with a new name of SBTestNew. So, we'll need to fix it if we want to use our services and queues in that database.

Mitch Wheat k 42 42 gold badges silver badges bronze badges. As a side note for others, if there are any open connections to the db, they would cause this delay. Add a comment. Active Oldest Votes. Improve this answer. Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges. Dara You cannot alter a database as long as there are transactions pending. Rollback immediate will terminate all of these.

Irfanullah Irfanullah 1 1 silver badge 4 4 bronze badges. Sean Perkins Sean Perkins 3 3 bronze badges. Mohamad Mahmoud Mohamad Mahmoud 3, 9 9 gold badges 43 43 silver badges 72 72 bronze badges. It is working fine and without take a time in alll cases — Mohamad Mahmoud. This drops any in-flight messages. Sign up or log in Sign up using Google.