"Gerd Güldenast" <gerd.gueldenast@hec.de> wrote in message
news:8c0964e1.0407160252.37380a03@posting.google.c om...
> Hi,
> I am having a problem with a replication over a Modem-Connection,
> which works fine over LAN. Has anyone experienced this problem before?
>
> Settings are:
> 2 SQL Servers 2000, SP3
> on Windows 2000
> Publischer Database ist about 3GB, Subscriber DB about 1,5GB
> Publisher and Subscriber are connected via 56Kbit Dial-Up
> --> The Replication worked fine now this way for about 6 Months now!
> overall the publisher has about 20 Subscribers all connected via
> dial-up and they all work fine.
>
> Behavior now is like this:
> - Dial Up works fine
> - Synch starts
> - Synch takes some time (Upload works fine)
> - Synch fails
> - Error Message(german):
> Der Prozess konnte die Zeilenmetadaten auf 'Subscriber' nicht
> abfragen.
> {call sp_MSgetmetadatabatch(?,?,?)}
> Allgemeiner Netzwerkfehler. Weitere Informationen finden Sie in der
> Dokumentation über Netzwerke.
> Der Prozess wurde erfolgreich beendet.
>
> If I connect the Subscriber-Server directly to the publisher server
> via LAN it all works fine.
>
> My thesis is, that there might be some kind of "timeout" or something,
> as it cant be the dial-up network, because we tried different modems
> and different server locations. And it all works fine on most of the
> other connedted subscribers. Only 2 other very big subscribers
> experience the same problem, therefore i assume it could have
> something to to with slow connection speed, timeouts and an inability
> of the SQL server to handle this.
>
> Anyone seen this before? Anyone can help me?
>
> Thanks and Best Regards,
> Gerd

You might want to post this in microsoft.public.sqlserver.replication.

Simon