SQL Server Performance

Transactional replication:data is not synchronised

Discussion in 'SQL Server 2005 Replication' started by ashis.deb, Jan 22, 2009.

  1. ashis.deb New Member

    Hi ,
    I have one issue in trasactional replication.Data is not getting synchronised between publisher and subscriber.If i run 'select count(1) from <Table> on both pub/sub' ,gets differnet count,not same.There is huge differnce almost like 2000 rows are not synchronised.But i am not able to see any error in replication monitor.
    Please suggect how to resolve this issue.As it is 24/7 prod i don't want to do reinitialize.
    Thanks,
    Litu
  2. ndinakar Member

    If the table is not too big (< xx,000 rows) you can drop the article from publication and add it back. This will reinitialize just that table. Rest of your replication will not be affected. Just make sure you do this during night time or when during off hours.
  3. ashis.deb New Member

    Thanks for your reply.But how I will get to know which article has the problem.Please let me know Asap.
    Thanks,
    Litu
  4. ndinakar Member

    Run a script to get table counts on both publisher and subscriber when there is no activity (night time?)...
  5. dineshasanka Moderator

    You can run a update to same table
    Update table SET ID = ID
  6. satya Moderator

    On top of what folks referred above do you see any errors on error or replication log?

Share This Page