SQL 2016 Replication Error Recovery

SQL Server 2016 Replication: in Replication Monitor one of my publications is in error status. I want to be *sure* not to reinitialize the subscription, I just want replication to start up where it left off.

Using Replication Monitor, if I right click on the publication that's in error and choose "start synchronizing," will replication simply pick up where it left off, or is there more that I need to know?
LVL 7
bcnagelAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bcnagelAuthor Commented:
The answer to my question above is that the "start synchronizing" command wakes up the distribution agent and starts checking the distribution database for changes, then applying them to the subscriber.

One way you can see this command working is that it will restart the SQL Agent job associated with the publication that you restarted (under the REPL-Distribution category).

In my case, I was seeing an error in Replication Monitor and the REPL-Distribution SQL Agent job showed as failed. Once I issued the "start synchronizing" command, both errors cleared and I was back in business.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.