Home Forums SQL Server 2008 SQL Server 2008 - General Replication not working but replication monitor says all ok!! RE: Replication not working but replication monitor says all ok!!

  • February 20, 2018 at 10:55 am

    #1980503

    steve.roberts 86619 - Tuesday, February 20, 2018 9:58 AM

    Hi,

    Earlier on today one of our DBs started to fall behind and isn't replicating anymore - normally opening up Replication Monitor would reveal some red crosses but all green and says it is delivering transactions?

    How can I find out why it stopped working - we haven't made any changes today.

    Check if all of the agents are running.
    In the distribution databases, check the delivered and undelivered transactions by querying MSdistribution_status
    In the distribution database, query the tables MSrepl_errors and MSdistribution_history.
    You can also query the history tables in the distribution databases - query whichever ones apply to whatever type of replication you are using such as MSlogreader_history for transactional, MSmerge_history for merge, MSsnapshot_history for snapshot, etc)

    Sue