Unanswered: Log reader fails on transactional replication
I'm getting these two errors that are stopping my transaction replication:
Another log reader is replicating the database.
The process could not set the last distributed transaction.
This is the setup:
5 servers replicating with immediate updating and transactional replication. 1 central server that is the distributor and publishes to the other 4 servers, and also subscribes to each of the other 4 servers. Each of the 4 servers subscribes to the main server and publishes to the main server as well. 1 of those servers is failing every couple of hours with the above errors. If I restart the Log Reader Agent (the agent that is failing), it restarts just fine, catches up with its work, and then fails in the same way a few hours later.
All the servers are SQL 2000 SP4 running on Windows 2003 SP1.
Anybody have anything that might help me get to the bottom of this (or at the very least get around it)? Let me know if I can provide more information for you.