all groups > sql server replication > november 2003 >
You're in the

sql server replication

group:

Distribution Agent Profile Settings


Distribution Agent Profile Settings Frank
11/25/2003 2:20:47 PM
sql server replication:
I continually get a Distribution Agent failure whenever I
a loose a connection (network error, server maintenance,
etc.) to one of my push subscribers for about 20 minutes.
Is there a way to increase this time so the agent will
continute to try to connect for 2 or 3 hours instead of
failing after 20 minutes?

I am currently using the default Distribution agent
profile settings. I'm hoping that adjusting one of these
settings will fix my problem.

Distribution Agent Profile Settings chris
11/26/2003 7:57:02 AM
I havent tested this, but it looks to me like the -
QueryTimeout under the Default Agent Profile would
probably be your guy. Try it out.

[quoted text, click to view]
AddThis Social Bookmark Button