SEO

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

"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