Routing and Distribution
In this section, I’ll move the manufacturing database to another SQL Server instance to demonstrate how to configure Service Broker networking. Although communicating between two machines is more impressive, if you have only one machine, you can use two instances on the same machine to set up a remote Service Broker connection. To set up a dialog initiator in another instance to test communications, detach the Manufacturing database, move the Manufacturing.mdf and Manufacturing_log.ldf files to the second instance, and attach the database to the second instance.
In the instance you have been using for the previous samples, detach the Manufacturing database with this command:
sp_detach_db Manufacturing
Move the Manufacturing.mdf ...
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
