I went back and checked the sqlserveragent and it starts automatically.
I further looked at the history records for the snapshot agents and they
were firing correctly, every hour or so.
But, the publishing agent had not run in over a week. I had to
reinitialize (run agent now) it to make it run. It did say the
sqlserveragent was running there to (within the properties window of the
publication)
Agent properties indicated an every two hours/daily publication.
I did not see anything in the log that referred to the replication. Only
backup information.
Any ideas on what I could check next?
Thanks
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