Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Network latency and retry attempts in Repl.

Author  Topic 

john.burns
Posting Yak Master

100 Posts

Posted - 2007-03-08 : 10:28:36
I'm experiencing some network latency which sometimes causes my replication to fail. (timeout - was retried 10 times)

I would like to increase the number of retries to maybe buy me some more time.

Is this the right way?

Goto publisher/agent properties/adavanced
then change retry attempts


Do I have to stop syncronizing and then restart to pick up change??

Thanks

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-03-09 : 06:02:29
nope, that would be enough, but this type of problem should be addressed else it'll re-occur and exceed the retry threshold you've set


--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -