Replication verification

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  January 22, 2010 at 9:37 am

  #138402

  Hi All

  I am looking for a verification method such that I can check that all articles specified in Msarticles are present on all subscribers.

  So I'm guessing this will effectively query the MSarticles table and join to the necessary other tables to build a list of publisher, subscriber and articles. I can then use this information to match the contents of sysobjects on each and every subscriber. I'm thinking SSIS may do a job here, does anyone have any ideas ?

• murthykalyani

  SSCarpal Tunnel

  Points: 4500

  More actions

  January 22, 2010 at 10:54 am

  #1107463

  Replication monitor is there, if any thing goes wrong, that publication will be marked red if it is out of sync or if replication is failing.

  To me there is no need for you manually verify this.