SQL Patching Questions

For this website
https://technet.microsoft.com/en-us/library/ff803383.aspx


 For these two rows, I have a question
 Product Version | Latest Service Pack  | Latest GDR Update  | Latest Cumulative Update  | CU Release Date |  General Guidance  

 SQL Server 2016  | SP2 (KB 4052908)   | KB4057118                 | CU 8 (KB 4077064)               | 3/19/2018            | SQL Server 2016 Installation  

 SQL Server 2012  | SP4 (KB 4018073)   | KB4057116                 |  N/A                                         |                               |SQL Server 2012 Installation

 My SQL server is in SQL Server 2016 SP2 (KB 4052908), Do I still need to install  KB4057118 ?
 SQL Server  is in 2012 SP4 (KB 4018073), do I still need to install KB4057116?  

 Please help me clarify it. Thanks
wasabi3689Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
This is really unclear... but the GDR update states it is for SP1 and it was released prior to SP2 so SP2 could contain it already.

GDRs are quick fixes so they are released outside the standard Cumulative Updates or even Service Packs and they should be included in the next CU or SP.

OTOH, you may simply try to install KB4057118 GDR because the installation must check whether the SQL Server version is suitable for this patch.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pcelbaCommented:
Some searching showed I am correct with the above post. This article says GDRs are cumulated to CUs and CUs are then cumulated to SPs...

Even when SQL 2012 SP4 does not contain KB4057116 there is no need to install GDR when you don't care about this specific problem.
0
pcelbaCommented:
Hi wasabi3689,

was the information about MS patches philosophy sufficient for your further decision? Do you have additional questions?

We are here to help.

Regards
Pavel
0
pcelbaCommented:
Correct information was provided, question author does not communicate with us.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.