June 8, 2017 at 2:05 pm
Stupid question. Say i'm using sql server 2014 service pack 1. I need to upgrade to service pack 2. Can I simply install 4013098 Cumulative update package 5 (CU5) for SQL Server 2014 Service Pack 2 or do I need to first install service pack 2 then install the cumulative update?
June 8, 2017 at 2:10 pm
No, that CU is for instances that are running SP2, so service pack first, then CU
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 8, 2017 at 4:22 pm
+1. Install SPs and then the latest CU. CUs include previous CUs.
June 9, 2017 at 6:13 am
what If I have an 2012 instance on SP1 and I need to get it to SP3. Do I need to install SP2 then SP3 or just SP3? I'm assuming just SP3 however I have to ask. I've been tasked w/ bringing all of our instances up to date.
June 9, 2017 at 6:27 am
Just SP3
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2017 at 8:23 am
Service packs include previous service packs and CUs up to the SP.
Cumulative Updates include all CUs since the base where they started (RTM or SP level)
You only need the latest of each.
If I have an RTM instance for 2012, I'd apply:
- SP3
- CU#9 for SP3
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply