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  Import/Export (DTS) and Replication (2000)  Replicas will not sync all changes

Author  Topic  cwillsh Starting Member 2 Posts Posted - 2003-04-24 : 13:29:11 Environment: An Internet server contains a database that is Published. A Push Merge replication is generated every hour to a remote site to accomplish synchronization. Issue: Not all records are synchronizing. Manually comparing tables after multiple merge replications reveals discrepancy in the number of records. Probable Cause: After restoring the snapshot of the replicated database at the remote site, the users began entering data into that database PRIOR to the initial synchronization with the publisher. The publisher is not receiving any of the data prior to the sync. Needed Solution: How do we get two databases, originally created from the same backup to compare and synchronize?