SQL Server Performance Forum – Threads Archive
Replication Monitoring Help
Hello Friends, If any of the agent[snapshot, log reader, Q reader, Distribution, Merge] fails, is there any command(sps) which will capture this information? I#%92m basically looking to read a log if the above agents fail and capture the record or a SP which would trigger a alert if it fails or some ‘key text#%92 in syslogs which I can query for the failure. Bharath KumarWhy not output the agentlog –http://support.microsoft.com/kb/312292 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Check MSrepl_errors and MSmerge_errorlineage tables…and also see "Replication Stored Procedures (Troubleshooting) "… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>