April 21, 2008 at 8:26 am
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.
November 29, 2013 at 12:04 pm
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.
January 8, 2014 at 5:38 pm
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...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply