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

Marcello Miorelli
  • 16,170
  • 52
  • 163
  • 300
  • 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 03 '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 05 '18 at 15:17

1 Answers1

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.

Kin Shah
  • 62,225
  • 6
  • 120
  • 236