November 29, 2004 at 2:31 pm
I have a transactional replication and The replication stopped few hours back.I haven't found any info in the sql server logs regarding this failure. Where can i check the reason behind the replication failure.And how can i fix this.
Thanks.
November 29, 2004 at 2:47 pm
Sahana,
Replication errors and logs are stored with the Replication Agent history.
Go to Replication Monitor on the distributor server using Enterprise MAnager. Expand Publishers and go to the publishing server. Within that branch there will be a list of publications (If you see a red "X" that indicates a problem).
When you open the publications you will get a list of the various agents (snapshot, log reader, distributor). Right-click on the agent and select Agent History. Hopefully you can find the problem by inspecting these logs.
Scott Thornburg
Volt Information Sciences
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply