Patching SQL Server 2016
5
votes
4
answers
3913
views
Most of my SQL Servers are on 2016 SP2. The security group have identified that I need a later security update applied and as SP2 is out of support this year I planned to just patch it up to SP3.
The problem is I have never actually patched SQL Server and was wondering what a good process would be to follow when applying the service pack. I have seen some online, all roughly the same, but just need some opinions on the best way to go about it.
Some questions I have, from looking at these processes online are:
- I'm assuming the SQL Server instance will need to be restarted. Is this done automatically when installing the patch?
- Does all activity on the instance need to be stopped? I.e., do all application services communicating with the instance need to be shut down?
- Should the SQL Agent be stopped as well?
Asked by Garry
(53 rep)
Mar 3, 2022, 10:39 AM
Last activity: Jun 19, 2023, 08:46 PM
Last activity: Jun 19, 2023, 08:46 PM