December 29, 2008 at 4:15 am
if i run the procedure sp_article_validation for some of my articles in a certain publication i get a different number than if i ran a count(*) on that table.
If i run a count(*) on the publishing table (with the filters) i get the same value as the subscribing table but not when i run teh validation procedure above. Its not as if its only a couple of rows out but its about 200k rows!!!
any iedas why it may be doing this? All other publications are fine.....
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
December 29, 2008 at 11:15 am
Are the publisher and subscriber the same version?
There could be issues when you use 2000 vs 7 vs 2005...
* Noel
December 30, 2008 at 3:02 am
i think i may have an answer for why it is happening. Every evening we perform a delete of certain tables from that publication (on the replicated server) to keep a rolling 3mths of data (the filter on the articles are rolling 3mths too). Could this be messing up the checksum in anyway?
If this is the issue, is there any other way of keeping a rolling amount of data apart from from creating a daily snapshot?
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
January 5, 2009 at 4:11 am
anyone??
There must be a better solution than creating a snapshot every day/week......?
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
January 5, 2009 at 9:03 am
row counts are not necessarily the same as the actual rows.
You should use tablediff or any other diff tool to determine if the rows are exactly the same. If they are not you can sync the tables using the script generated by the sync-tool of your choosing.
There are occasions in which the log-reader could miss some transactions
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply