My replication is a snapshot replication with a publisher push. (I am
replicating a customer file from one database to another on the same
server)
It is scheduled to run every 2 hours. (Mssql server)
Sometimes it just quits replicating and I have to restart the process.
When it quit last time, the last successful snapshot agent history
record was on the 10th and I noted the activity log was dated the 11th.
I connected the dots and figured the two occurances were related.
This has been going on for over a year now, and I hope one day to solve
it.
Any guidance would be greatly appreciated
Arnie
-----Original Message-----
From: Bellizzi Christopher - IBG
[mailto:mssqldba-ezmlmshield-x90277607.[Email address protected]
Sent: Tuesday, April 18, 2006 10:32 AM
To: LazyDBA Discussion
Subject: RE: replication
It starts automatically.
Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886
-----Original Message-----
From: Richard Baumet
[mailto:mssqldba-ezmlmshield-x70407296.[Email address protected]
Sent: Tuesday, April 18, 2006 11:25 AM
To: LazyDBA Discussion
Subject: RE: replication
Are you talking about the publisher, distributor, or the subscriber
rebooting?
-----Original Message-----
From: Arnie
[mailto:mssqldba-ezmlmshield-x68921576.[Email address protected]
Sent: Tuesday, April 18, 2006 7:43 AM
To: LazyDBA Discussion
Subject: replication
Gentlemen & Ladies
Question, how do I make my replication restart automatically when a
server is rebooted. I guess I expected it to do so automatically, but
apparently I have to do something?
Thanks a lot
Arnie
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the
exclusive and confidential use of the addressee. Any other distribution,
use, reproduction or alteration of the information contained in this
electronic message, by the addressee or by any other recipient, without
the prior written consent of the sender is strictly prohibited. If you
have received this electronic message in error, please notify the
sender.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************
This e-mail and any files transmitted with it are proprietary and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this e-mail in error please notify the
sender. Please note that any views or opinions presented in this e-mail
are solely those of the author and do not necessarily represent those of
ITT Industries, Inc. The recipient should check this e-mail and any
attachments for the presence of viruses. ITT Industries accepts no
liability for any damage caused by any virus transmitted by this e-mail.
************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page