dbTalk Databases Forums  

Service Broker with offline application

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Service Broker with offline application in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
fireball
 
Posts: n/a

Default Service Broker with offline application - 03-23-2007 , 04:38 AM






Some of my receiving service side applications usually work offline, and
they only are supposed to get connected to the network once/few times a day,
to send/receive Service Broker messages.

Will my sending service side application (permanent connected to the
network) keep retrying repeatedly to connect to the receiver?

- Is retrying like that time consuming?.

- I don't like it keeping trying over and over. Is retrying behavior
configurable?





thx









Reply With Quote
  #2  
Old   
Alan Brewer [MSFT]
 
Posts: n/a

Default Re: Service Broker with offline application - 03-23-2007 , 01:09 PM






A longer answer is on the thread posted in
microsoft.public.sqlserver.programming.

The short answers are that the retries should not be time-consuming or a
performance issue, and they are not configurable, but do adjust to longer
intervals between retries if multiple retries do not succeed.

The basic retry mechanism is described in the "Message Acknowledgement"
section of the "Service Broker Communication Protocols" topic in the SQL
Server 2005 Books Online:
http://msdn2.microsoft.com/en-us/library/ms166061.aspx


--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.