Syndicate

SQL Replication Error Summary

Wed, 12/02/2009 - 00:03 | sqlguychuck

Average:

Your rating: NoneAverage: 4.5(2 votes)

This proc will monitor for errors so you don't have to monitor Replication Monitor (Replmon) constantly, nor are you forced to use the inflexible builtin SQL Agent Job alerting. Schedule it as a job on your distributor box and it will email you only when there are errors. It will provide a code segment for you to run to see all the errors if there were multiple lines of errors, which is common, but the comments column should be enough to figure it out or at least point out that there is a problem. The Replmon will retry and everything will look good, and only temporarily show a red x, this script will help you from missing the errors before it is too late. I removed my referenc to my handy prc_internalsendmail procedure that helps automating profile creation and sending mail to make this script more generic. Also, check out my other good replication proc for monitoring replication latency that could capture unknown issues: http://www.sqlwebpedia.com/content/sql-replication-undelivered-command-count