Merge replication error

Hello, everybody,
I'm using SQL 2000 SP4 on W2K & W2003 Server. In the last 2 weeks, I
encounter a very annoying problem with the replication:
"The merge process encountered an unexpected network error. The connection
to Publisher 'AR-MAIN' is no longer available" - error number -2147199469
And along with that: "General network error. Check your network
documentation."
The problem is that the error occurs only sometime.
And only occurs to the merge process on one table (no filters, table to
table replication).
The others replicate just fine...
However, it's true that this one is the most accesed table.
I have a VPN connection between the Publisher's site and the Subcriber.
But the VPN link is stable, there are no bottlenecks - only the two SQL
servers seem to have problems.
Any idea? Could it be something related to the SQL server, or should I look
elsewhere?
Thanks,
Valentin
This error is most frequently transient and caused by lossy network
connections. Try using the verbose profile to see if this shows the error
which occurs before this error which is sometimes masked by the general
network error.
Hilary Cotter
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
"Valentin Holban" <ValentinHolban@.discussions.microsoft.com> wrote in
message news:D362A7BA-5D76-480E-9B94-4C145F65B520@.microsoft.com...
> Hello, everybody,
> I'm using SQL 2000 SP4 on W2K & W2003 Server. In the last 2 weeks, I
> encounter a very annoying problem with the replication:
> "The merge process encountered an unexpected network error. The connection
> to Publisher 'AR-MAIN' is no longer available" - error number -2147199469
> And along with that: "General network error. Check your network
> documentation."
> The problem is that the error occurs only sometime.
> And only occurs to the merge process on one table (no filters, table to
> table replication).
> The others replicate just fine...
> However, it's true that this one is the most accesed table.
> I have a VPN connection between the Publisher's site and the Subcriber.
> But the VPN link is stable, there are no bottlenecks - only the two SQL
> servers seem to have problems.
> Any idea? Could it be something related to the SQL server, or should I
> look
> elsewhere?
> Thanks,
> Valentin