Inline Data Validation and Reinitialization
A new function within SQL Server replication is inline data validation. This function helps subscribers and publishers stay synchronized by counting rows or performing checksums. Validation can be configured for merge, transactional, and snapshot replication. You can also configure all subscriptions or specify subscriptions for validation.
Checksums, if you opt to use them, are 32-bit redundancy checks performed on a column-by-column basis. This requires a lot of processing power and should be scheduled to run during the most inactive times on the server.
If you have vertical partitioning set up for replication, the checksum will not work because the columns are going to be different between the publisher ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
