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_MSgetmetadat abatch(?,?,?)}
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
1  2153 
"Gerd Güldenast" <ge************ *@hec.de> wrote in message
news:8c******** *************** ***@posting.goo gle.com... 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_MSgetmetadat abatch(?,?,?)}
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.publi c.sqlserver.rep lication.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Laurence Breeze |
last post by:
I don't know if anyone can help with this, I've got replication running
between 2 SQLServer installations, the distributor is on the the same
server as subscriber. Replication is a once a day snapshot and all has
been working well until recently.
I needed to make a change to the replication and deleted and recreated
the subscription and now it doesn't work. The snapshot runs as before
but the subscription fails within a second or 2...
|
by: dlesandrini |
last post by:
I need advice about my decision to go with Replication in general.
This post was placed on the Microsoft Replication newsgroup, but
I really value the feedback that comes from this group as well.
I have a new client who want their Excel data moved to Access.
They have only 4-6 users of this data and a couple of them want
to work disconnected, with their laptops and synchronize when
they come into the office. The database will be...
|
by: David |
last post by:
Hi,
I have a problem in getting the status of the modem. Here is my code:
HANDLE hfile;
DCB dcb;
hfile = CreateFile("BCM V.92 56K Modem", GENERIC_READ, 0, NULL, OPEN_EXISTING, 0, NULL);
i(hfile != INVALID_HANDLE_VALUE)
|
by: yom |
last post by:
Hi all.
I am having some troubles with an application that has to open a
dialup up connection.
I am using the Ras API RasDial to call the remote modem an all works
properly.
I am also able to close the connection by calling the RasHangUp API:
in this case i can redial the number and open a new connection.
The problem comes out when the line is busy or when any other error is
|
by: Chad J. Lemmer |
last post by:
We purchased 2 new HP DL385 servers that will be used for MySQL 5 in a
replication environment.
Server 1 (Master) is connected gigabit to our Cisco 3550 core switch
The Cisco 3550 core switch is connected gigabit over fiber to a Cisco 3548
switch in another building.
Server 2 (Slave) is connected to the Cisco 3548 on a 100MB switched port.
| | |
by: Juan Antonio Villa |
last post by:
Hello, I'm having a problem replicating a simple database using the binary
log replication, here is the problem:
When the master sends an update to the slave, an example update reads as
follows:
UPDATE MainInfo SET dAddress='38 Holland Blvd', dCity='miami',
dState='FL', dZip='33000', dCountry='USA', dPhone='999987565',
dNum='AC15857', dName='Michael A Scott' WHERE did=22'
|
by: Gert van der Kooij |
last post by:
Hi,
Our SQL Replication is between DB2 databases on Windows servers.
I'm searching for the document which tells me how to migrate our SQL
Replication environment from V8 to V9 (we also need to migrate from V7
to V8 but that's fully described so that's no problem).
The PDF 'Migrating to Replication Version 9' doesn't contain a
description about migrating SQL Replication, only Q replication. I found
some links to PDF manuals which should...
|
by: Query Builder |
last post by:
Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
When I try to set up the replication thru the script, it created the
|
by: shgzs33 |
last post by:
I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a
replication betwwen them: SERVER1 as Publisher and SERVER2 as
subscriber.
the problem is that SERVER2 is runnint on port 2433 and -I dont know
why- I cannot switch it to port 1433.
When trying to push a new subscription on SERVER1 to SERVER2, it tells
that:
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
