Hi,

every morning my replications down in timeOut and i can Restart !
Why replication TimeOut ? and how can repair this ?

Thank's

Christophe,
you could investigate blocking as the most likely cause. Try increasing the
timeput parameter of your merge/distribution agent and see if this sorts the
problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Bump QueryTimeout to something larger. Also investigate your network
latency/connectivity over night. It sounds like it works during the day, but
fails at night.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]