SQL Server Performance

Replication Monitoring Help

Discussion in 'SQL Server 2005 Replication' started by knowledgebaseforbk, May 28, 2007.

  1. knowledgebaseforbk New Member

    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 Kumar

  2. satya Moderator

  3. MohammedU New Member

    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.

Share This Page