Merge Replication - How long schould I wait?
Thom,
When you said you see that replication agent try make a
connection...Did you see it connected (log in) to
subscriber by call sp_who2...you should see that the agent
is running. By look at the agent history you should see
that it is trying but fail...and keep trying. If this is
the case try to increase KeepAliveMessageInterval and
QueryTimeOut in Merge Agent Profile from 300 to 1200.
Hope this help...Let me know if not.
Thanks,
Rachan Terrell
KeepAliveMessageInterval:
The number of seconds before history thread checks if any
of the existing connections is waiting for a response from
the server. This value can be increased to avoid getting
the agent marked as suspect by the checkup agent when
executing a long-running batch.
QueryTimeOut:
The number of seconds before the queries issued by the
agent times out.
Quote:
>-----Original Message-----
>> Hi all,
>> I did big update on subscriber and start replication.
After ~14 hours
>> replication session was not at end. So I stopped it,
and started
>> again, but now I see that replication agent try make a
connection to
>> subscriber, but it take too very long time without
effect.
>> Any Idea why it is so? Or someone have similar
situation?
>> Thanks for any help
>> Thom.
>I found it as usefull
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q312292, and still
Quote:
