We are using data replication across similar platforms (NT server 4.0 w/
sp 6, SQL 7.0 w/ sp3) across our network. The Publisher and Distributor are on
the same machine. The Subscription is pushed to the other machine. It is set to
run every hour from 5 am to 5 pm, M-F. The Distribution Agent fails after the
last run of the day. The next morning, I have to come in and enable the
distribution again. As I don't get here by 5, the first two repls are missed. Not
mission critical, but annoying.
Have deleted and recreated the publication, publisher and distributor
several times to see if I can make a difference. No joy. Have changed the times
of the distribution several times to see if it was interferring with any other
jobs. No joy. Have found no other documentation.
Please let us know what we can do to correct this problem. Thank you.