Hi,

We are running SQLserver 2000 SP2 on Publisher (Server2) and Subscriber (Server2). Where Remote distributor is on Server 2.

Sometimes I am getting the below error

"Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication"

When I followed the microsoft workaround by looking to the below articles. But sometime this works and sometimes it doesnot. Always this happens when there is update transactions Occurs on Publisher.
This results in doing a complete snapshot of 30 Gig of database towards the network to remote branch. which takes almost 15 hours to complete the entire snapshot.

http://support.microsoft.com/default...b;en-us;811030

http://support.microsoft.com/default...b;en-us;308865

If anyone got any other workaround or fix from Microsoft, please help me by giving this info.

Thanks,
Anu