0

I have set up a transactional replication initialized using backup for a big database(1.6TB).Due to some error(space issue in the subscriber) the replication was not happening and there were replication error for the past 5 days. So i added space and now i am getting the 20598 and 547 error in Distribution to Subscriber.

I changed the Agent profile and created a custom profile with the -skipError values as 20598:547. I restarted the Distribution agent by stopping and starting the distribution job in the subscriber(PULL subscriber). After restarting i see that, Distributor to Subscriber is initialized in replication monitor,but i don't see that the skipping is happening.

How can i solve this issue.?

I prefer not to drop Publisher/Subscriber as i am initializing using backup and it is a big database.

1

You don't see the "skipped # rows" in the message window? Can you maybe post the window screenshot?

Like this blog here (it did what you did, skipped 20598:547), restarted agent https://www.percyreyes.com/2016/07/the-skiperrors-parameter-for.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.