Microsoft® SQL Server® 2012 Bible

647 CHAPTER 25 Asynchronous Messaging with Service Broker IN THIS CHAPTER Using Message Multicast Defi ning a Work Queue Queuing ...

648 Part V: Enterprise Data Management FIGURE 25-1 Asynchronous Shipping Notifi cation with Service Broker. Shipping Manager Shi ...

649 Chapter 25: Asynchronous Messaging with Service Broker 25 statement opens a conversation with a destination service. If a co ...

650 Part V: Enterprise Data Management CREATE SERVICE InitiatorService ON QUEUE [dbo].[InitiatorQueue]; GO CREATE SERVICE Target ...

651 Chapter 25: Asynchronous Messaging with Service Broker 25 WHERE name='HelloWorldMessage'; GO --Query the sys.service_contrac ...

652 Part V: Enterprise Data Management FROM SERVICE [InitiatorService] TO SERVICE 'TargetService' ON CONTRACT [HelloWorldContrac ...

653 Chapter 25: Asynchronous Messaging with Service Broker 25 Service Broker is not a trigger that can code when a message is pl ...

654 Part V: Enterprise Data Management BREAK ; END ; -- Process all messages in the conversation group. Notice -- that all proce ...

655 Chapter 25: Asynchronous Messaging with Service Broker 25 END ; END; -- Process all messages in conversation group. -- Commi ...

656 Part V: Enterprise Data Management Grant CONNECT permission on the Service Broker endpoint to PUBLIC or to a login. Ensure ...

657 Chapter 25: Asynchronous Messaging with Service Broker 25 TABLE 25 -1 Resources to Monitor Service Broker Activity Resource ...

658 Part V: Enterprise Data Management Catalog View Description sys.service_contract_usages This catalog view contains a row per ...

659 Chapter 25: Asynchronous Messaging with Service Broker 25 Summary Service Broker is one of those technologies that provide n ...

c25.indd 660c25.indd 660 7/31/2012 9:21:39 AM7/31/2012 9:21:39 AM http://www.it-ebooks.info ...

661 CHAPTER 26 Log Shipping IN THIS CHAPTER Confi guring a Warm Standby Server Using Management Studio and Transact-SQL Monitori ...

662 Part V: Enterprise Data Management A complete plan for high availability also includes a plan to handle true disasters. If t ...

663 Chapter 26: Log Shipping 26 expected RTO is, that way in the case of disaster there is an established expectation for gettin ...

664 Part V: Enterprise Data Management ■ (^) Log shipping provides redundancy at the database level and not at the SQL Server in ...

665 Chapter 26: Log Shipping 26 Log Shipping normally involves three SQL Servers: a primary server, a warm standby server, and a ...

666 Part V: Enterprise Data Management Best Practice The monitor server can be an instance on the destination server, but locati ...