Missing records on Subscriber - Validate Subscription?

Question

Post reply

Missing records on Subscriber - Validate Subscription?

Adrian Robertson

Mr or Mrs. 500

Points: 551
More actions
August 5, 2008 at 10:54 pm

#190716

I have a fairly basic replication model set up, with a single Publisher and a single Subscriber. No filtering takes place on any published articles.
Some records in a particular table don't exist on the Subscriber.
Other related tables are there in their entirety, but then again some related tables are not.
It's something I'll need to investigate as to how this started (I know some data was imported into the mentioned tables at the Publisher) but the immediate concern is how to synchronise the tables again, ideally without sending an entire snapshot to the Subscriber.
Would Validate Subscription do something along these lines?

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Grinja Hall of Fame Points: 3590 More actions · Answer 1

Validating a subscription will only notify if there are problems but it will not fix anything.

(I'm still new at this so someone should probably confirm).

You might want to check your conflict tables to make sure that your missing rows are not there.

ch.mohini Mr or Mrs. 500 Points: 557 More actions · Answer 2

1 st u check repl momitor.there is any row filtering

Adrian Robertson Mr or Mrs. 500 Points: 551 More actions · Answer 3

Thanks. There is no row filtering or column filtering, and although there are some conflicts none of these match the records that are missing.

I have done some digging and have found a utility that fixes the issues (in theory) but I have some new questions about this, so will start it in a new thread.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 4

Was following along - what is the new thread how did you resolve looking for the same answer too.

noeld SSC Guru Points: 96590 More actions · Answer 5

Adrian Robertson (8/6/2008)
Thanks. There is no row filtering or column filtering, and although there are some conflicts none of these match the records that are missing.
I have done some digging and have found a utility that fixes the issues (in theory) but I have some new questions about this, so will start it in a new thread.

validatesubscription does just that "valiadate" meaning it shows you if it is valid/invalid.

Are you talking about Merge or Transactional replication ?

* Noel