Re: Merge replication error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/11/04 

Date: Sat, 10 Jul 2004 21:51:52 -0400

but the network problem might exist only between this subscriber and
publisher.

I'd try to run a ping -t for a day and then look at the statistics to see if
a hicup occured.

You could run this keep alive script which will tell you exactly when you
get a failure.

save this as c:\keepalive.sql

WHILE 1<>2

BEGIN

SELECT GETDATE()

WAITFOR DELAY '00:00:01'

END

GO

Here is the batch file that I use to run this script:

osql -S hilary2kp -E -i c:\keepalive.sql -n

date /t

time /t 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"DBard" <DBard@discussions.microsoft.com> wrote in message
news:D10215EC-A700-4E92-8142-D567F8C50E34@microsoft.com...
> Paul - Thanks for your response.
>
> The connectivity is fine - which is proven by 4 databases on this same
server replicating just fine to the same subscriber.
>
> Another other ideas?
>
> - David
>
> "Paul Ibison" wrote:
>
> > Looks like a networking issue; when the error occurs, please try pinging
the
> > distributor from the subscriber, to test your network connectivity and
name
> > resolution.
> > Regards,
> > Paul Ibison
> >
> >
> >

Relevant Pages

  • RE: replication agent has not logged a progress message in 10 minutes
    ... Ask your network guys or run ... ping -t against this subscriber. ... Paul Ibison ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge replication error
    ... distributor from the subscriber, to test your network connectivity and name ... resolution. ... Paul Ibison ...
    (microsoft.public.sqlserver.replication)
  • Re: Newbie to Replication Subscriptions
    ... (even though on the network share in question "Everyone" had full rights) ... they'd get in that way but not with the localsystem account that is used by ... > publisher reads the files and bcp's them to the subscriber. ... > you are using NT authentication, the SQL Server agent ...
    (microsoft.public.sqlserver.replication)
  • Re: How to get the operator name?
    ... PhoneOperatorName returns the name from the currently connected service. ... If you are roaming you'll get the operator name of the current network which won't be the same as the "home" network to which the user is subscribed. ... subscriber has a contract with. ... cell tower owner) and I have seen it return a blank string. ...
    (microsoft.public.pocketpc.developer)
  • Re: Merge-Agent Error
    ... > synchronization information on the subscriber' is the right error message. ... >> The literal translation is something like: ... >> Rgds, ... >> Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)