SQl replication and backup monitoring

• Ch Ge

  Grasshopper

  Points: 20

  More actions

  September 21, 2005 at 8:47 am

  #110776

  Dear SQl Gurus,

  I am doing a backup and replication beteween two physially separate MS SQL servers

  One shall be acting as server and the other client; and also viceversa

  but both will be not be server and client at the same time:

   

  I need some answers/pointers to

  1. how to monitor replication queue and report any alarm that queue exceed certain

  threshold and possible cause is link congestion (try replication later)

  2. How to distinguish the above from link failure (possibly some SNMP trap I believe)

  3. How to troubleshoot that which site has the problem (between those two)?

   

  I would deeply appreciate for your quick feedback..

   

  thanks in advance

  Charles

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 21, 2005 at 10:34 am

  #591889

  SQL server has a replication monitor in Enterprise manager. It has detailed logs for all agents.