Guru's Guide to SQL Server Architecture and Internals, The

Validating Replicated Data

As with snapshot and merge replication, SQL Server can validate data replicated via a transactional replication publication. You can choose to verify merely that the publication tables on the subscriber and the publisher have the same number of rows, or you can verify checksums or binary checksums of the data in the tables. When you use checksum validation, the server compares a 32-bit cyclic redundancy check (CRC) for each table article on the publisher and subscriber. Because this CRC is computed on a column-by-column basis, the precise column order for an article can vary between the publisher and subscriber without affecting the comparison. Data from text and image columns is not included in the comparison.

To validate ...