Service Broker - Restarting after a failure

simonsabin — Thu, 07 Jun 2007 15:22:12 GMT

Video of showing how service broker continures to process queued messages even after a failure and restart

Asynchronous Processing Demo

simonsabin — Tue, 05 Dec 2006 22:13:34 GMT

This zip file contains a data dude project for deploying the demos associated with the Asynchronous Processing in SQL Server 2005 presentation.

Do deploy the database unzip the project to a folder and open the testdb.dbproj file. You will need to have Visual Studio for Database Professionals installed. (The deployment script for the database is also located in the zip file)

You will need to change the database connection to point to your server.

Right click on the testdb database and select deploy.

This will enable CLR on the server. The demo also needs xp_cmdshell enabling, this is not in the build for security reasons. To run that section of the demo please run the serverSettings.sql file in the scripts/scripts folder.

The Demo files are in the Demo folder and are named appropriately.

The replication demo assumes the server has been configured with a distributor for replication. This can be easily done in management studio by right clicking on the replication node and selecting "Enable Publishing and Distribution"

Service Broker Demos

Service Broker - Restarting after a failure

Asynchronous Processing Demo