sql server replication: Snapshot discrepancies (More records on destination). -- sql server replication

Snapshot discrepancies (More records on destination).

David Griffin
8/13/2003 2:15:14 PM

sql server replication:

I am using W2K SP3 and SQL 2000 SP2 and performing
snapshot replication between 2 servers. My destination
server is using a pull subscription and is run twice per
day. Every article is set to drop the existing table if
it exists and re-create the table. My problem is that
the destination server has more records in the one of the
tables than was processed during replication. When I
count the rows of the specific table, I receive 72
additional records on the destination server. Has anyone
seen this before? Anyone have any suggestions as to what
could be causing this?

TIA,
Dave

Re: Snapshot discrepancies (More records on destination).

Greg Yvkoff [MSFT]
8/14/2003 8:33:02 AM

Dave, use sp_publication_validation after you sync to verify the data. If
that doesn't work, then you'll need to profile the subscriber machine to
verify the table is being dropped and recreated. Also, is the subscriber
database used for queries only? Is it possible that someone else is
inserting data into the subscriber database? You may want to profile for
this as well.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

thanks.
greg

[quoted text, click to view]