Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Reinitialize subscriptions having data validation failures Expand / Collapse
Posted Monday, April 21, 2008 8:26 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 2, 2016 2:02 PM
Points: 547, Visits: 1,985
hi gurus!, i am new to replication so please be gentle...

I have become the new admistrator for our replication that has already been in place for about 3 months, its a transactional replication going every 10 minutes.

Now.. after reading i found out that there is a job called "Reinitialize subscriptions having data validation failures" which could do a count to monitor the replication being made, perfect! that's exactly what i need, but i want the count to be made but i dont' want automatically the reinitalization to start if there is an error count, i just want to get a notification. Is there any way to do this? if so please give me details of how to do this. I was looking in replication monitor but didn't not find anything.
Post #487995
Posted Friday, November 29, 2013 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 29, 2016 3:43 AM
Points: 3, Visits: 228
You can use the following SQL stored procedure : sp_publication_validation to check for the publication validation. You can also schedule this sql job to run at specific times.
Post #1518588
Posted Wednesday, January 8, 2014 5:38 PM


Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:39 PM
Points: 21, Visits: 93
You can manually run and monitor the validation using the replication monitor.

Open the replication monitor
Open the subscription you wish to validate
Chose the menu option "Validate Subscription"
You should probably select the "rowcount and checksum" option
Then the next sync, it will validate, and show the results in the subscription monitor window, and flag any articles that fail. You can start the sync manually if you like.

If you do have errors, sorting them out is another story... You can do it, but it is a slow manual procedure. I've had to do it a number of times when various client envs have left machines expire and I've had to get them resubscribed without initialisation so we don't lose transactional data. It is do-able, but slow...
Post #1529158
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse