March 29, 2017 at 4:45 pm
Do we need to stop the SQL Server service before applying SP2 for a SQL Server 2014 Production Instance?
March 30, 2017 at 4:40 am
Hi,
I suspect you may need to what I would do is leave it running, do the SP install and then if it needs a restart of the service it will tell you at the end, A quick restart is going to be less hassle than shutting it down for the duration of the SP install.
Hope this helps.
Nic
March 30, 2017 at 4:46 am
I've never installed a service pack without the SQL Server service running. The process runs scripts and does a whole lot of other stuff, so I suspect that if SQL Server weren't running, it would be automatically started for you. As Nic mentioned, you may or may not need a restart (of the server, not just the services) at the end.
John
March 30, 2017 at 7:29 am
sqlguy80 - Wednesday, March 29, 2017 4:45 PMDo we need to stop the SQL Server service before applying SP2 for a SQL Server 2014 Production Instance?
don't stop any instance before patching, if the pattch needs it, it will only start the instance anyway.
What you should plan for is an outage of the service whilst the SP is being applied, it will usually stop and start
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply