August 9, 2019 at 4:44 pm
Hi,
We are currently on SQL Server 2012 SPS 2.
I was wondering to get them up to date do I, go sps 3 and then 4 or can I just take sps 4?
Is there anything that I have to be concern about in installing these on a production unit.
Thank you
August 9, 2019 at 6:07 pm
You can go directly to the latest service pack - and I would also recommend applying the latest available CU for that service pack.
And yes - when applying to any environment it will cause a downtime and interrupt services. It should be scheduled after hours or a low usage time to avoid impacting the business.
If the production system is a cluster - you can avoid most of that downtime by applying the service pack and CU to the passive node. Then move the cluster groups to the upgraded node and then upgrade the other node.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 9, 2019 at 6:22 pm
Thanks I really appreciate the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply