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)  Pull Replication: -Validate option does not work

Author  Topic  rs02148 Starting Member 1 Post Posted - 2005-10-20 : 11:49:47 Hello, I'm using SQL Server 2000, where a Pull subscription is set up to run in continuous mode. I am trying to set up periodic validation (validate the replication by comparing the rowcounts of the 2 databases every 30 minutes). But this does not work. Here are the arguments I'm using to run the agent: -Publisher lab1 -PublisherDB [CCM0301] -Publication [CCM0301] -Distributor [lab1] -SubscriptionType 1 -Subscriber [BALT_SUB] -SubscriberSecurityMode 1 -SubscriberDB [CCM0301] -Continuous -MaxBCPThreads 3 -UseInprocLoader -Validate 1 -ValidateInterval 30 -Output C:\ReplOutput.txt Notice the "-Validate 1 -ValidateInterval 30" options. This is supposed to validate the replication every 30 minutes. Why doesn't periodic validation work? If I go to Replication Monitor -> Publishers -> LAB1 -> CCM0301:CCM0301, right-click and select "Validate all subscriptions", then the validation works. But trying to run it periodically by using the -Validate option does not work. I would appreciate any help. Thanks! Rashmi