Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication Problem

Author  Topic 

mjeddi
Starting Member

5 Posts

Posted - 2005-01-04 : 07:35:26
I have set up a transactional replication. I a have a central publication and many subscribers. Articles in one subscriber are missing some records . Is there a way or a tool that can help me synchronize articles on the pulisher with those on the subscriber.

Thanks a lot for your help.

Regards.

MJeddi

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-01-05 : 00:06:44
you can rerun the snapshot to sync
a. data (in the article option of the publisher - choose delete all rows instead of drop table)
b. schema and data (choose drop table so that replication will create the subscriber articles

or explore the possibility that replication might be slow to commit

otherwise, not sure how records in SUBSCRIBER are missing.

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -