What happen to Service Broker Queue?

  • sihaab

    SSCommitted

    Points: 1742

    Here is my situation, I have a Service Broker Queue with at least 250 messages not processed yet as a backlog. Everything works normal and these messages will be processed normally. Suddenly, my database server crashed and windows server box restarting. After a while, Windows comes back and SQL Server Engine is ready for business. Here is my question,

    What will happen to my 250 unprocessed messages after restart?

    Will it be still available in the queue as not processed and ready to be processed?

    Or, will it be wiped out and queue will have no messages to process and I have to initiate the process queue with new messages?

    I appreciate the expert knowledge on this matter.

    Thanks.

  • Nils Gustav Stråbø

    SSChampion

    Points: 11259

    The messages will still be there.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply