Home > Archive > MS SQL Server Replication > February 2006 > PollingInterval









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author PollingInterval
mrprice

2006-02-25, 9:45 am

Does the PollingInterval parameter on the LogReader and Distribution Agent
need to be the same? I've found that if I don't change the default in the
job (no parameter) for the LogReader Agent and I include the parameter in the
job for the Distribution Agent, the Distribution Agent just hangs on Step1
(Starting agent).

Thanks,
Mark
Hilary Cotter

2006-02-25, 9:45 am

they don't have to be the same, but ideally the log reader agent should be
more than the distribution agent. I have not noticed them hanging.

--
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



"mrprice" <mrprice@discussions.microsoft.com> wrote in message
news:E8218B91-B40F-46A9-BFA2- AFE3383C3FD5@microso
ft.com...
> Does the PollingInterval parameter on the LogReader and Distribution Agent
> need to be the same? I've found that if I don't change the default in the
> job (no parameter) for the LogReader Agent and I include the parameter in
> the
> job for the Distribution Agent, the Distribution Agent just hangs on Step1
> (Starting agent).
>
> Thanks,
> Mark



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com