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
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.
Thanks for your reply.But how I will get to know which article has the problem.Please let me know Asap. Thanks, Litu
Run a script to get table counts on both publisher and subscriber when there is no activity (night time?)...