0

Applying cumulative updates and service packs on sql server 2016 -

The server is involved in transactional replication, being a publisher,

The server is also a virtual machine.

I need to stop the logreader application in order to carry on with the updates.

what could be a safe way to get this done?

enter image description here

  • 1
    Just stop the job. But I just ignore the "check files in use" page and then restart the server after the updates are done. – Tara Kizer Oct 3 '18 at 17:07
  • Yes, I ended up doing that too, however, our of 12 servers, 1 got corrupted and it kep me thinking, had I stopped all services and applications would it have corrupted? But actually that server had not been patched for a while and had excess patching for one shot, I am tending to blame that for the unfortunate event. – Marcello Miorelli Oct 5 '18 at 15:17
0

You can stop the log reader agent job in sql server agent. It is used by publications that are involved in t-rep. It basically copies the transactions marked for replication from the transaction log into the distribution database. Should be safe to stop it.

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.