Snapshot Replication - Missing Rows

• oraculum

  SSCrazy

  Points: 2981

  More actions

  November 5, 2009 at 2:56 am

  #206299

  I have setup snapshot replication form a sql 2005 to sql 2000 box. This has been running for over a year!

  We had a few issues with timings of various overnight batch jobs being completed before the snapshot is taken, so to ensure that all rows are copied I created a validate rows proc that counts the rows in all tables on the publisher database then counts rows after the snapshot has been applied on the subscriber - does a match count and emails misssing rows in the subscriber db..

  Today we have 200,000 rows less in the subscriber 'payments' table and I cannot fathom why..

  I have created and run the below queries which validate that the rows were created into the 32 BCP files during the snapshot, and another query that tells me that all these rows were applied to the subscriber...

  There are no errors anywhere - but i am missing 200,000 rows... in a very important table!

  any ideas..??

  select * from dbo.MSsnapshot_history

  where start_time >getdate()-1 and comments like '%Bulk copied snapshot data for article ''PAYMENTS%'

  order by time desc

  and

  select * from dbo.MSdistribution_history

  where start_time >getdate()-1 and comments like '%Bulk copied data into table ''PAYMENTS''%'

  order by time desc

  snapshot historyDistribution history

  8498084980

  8557085570

  105168105168

  105881105881

  108869108869

  111851111851

  116233116233

  122843122843

  130299130299

  143746143746

  154634154634

  159505159505

  161440161440

  164830164830

  165513165513

  166162166162

  170606170606

  180374180374

  193249193249

  223372223372

  225147225147

  231200231200

  237087237087

  237593237593

  238589238589

  245009245009

  252761252761

  282955282955

  284929284929

  287993287993

  312184312184

  356008356008

  60465806046580

  Oraculum