This article describes the updates to the SQL Server incremental servicing model (ISM) for SQL Server 2017 as they relate to the Service Pack (SP) policy. For more information about the changes to the SQL Server ISM, see An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems.
Note Earlier versions of SQL Server are not affected by this SP policy change. Service Packs (SPs) will continue to be provided for the reminder of mainstream support for SQL Server 2014 and SQL Server 2016.
SQL Server 2017 and later versions will no longer receive SPs
The Modern Servicing Model (MSM)
Starting from SQL Server 2017:
-
SPs will no longer be available. Only Cumulative Updates (CUs) and critical updates (GDRs) will be provided.
-
CUs will contain localized content if it's necessary as what SPs have done.
-
CUs will be delivered more frequently at first and then less frequently: every month for the first 12 months, and then every quarter for the final four years of the five-year mainstream lifecycle.
Note The MSM only applies to SQL Server 2017 and later versions.
FAQ
-
Q: SPs were fully localized, and one update file was released for every supported language. How will this work with only CUs?
-
Q: Microsoft provided "slipstream" packages (RTM+SPn in a single media package) at each SP at approximately yearly intervals. How will this work without SPs?
-
Q: Previously, when SP2 was released, for example, an instance on the RTM baseline would have to be upgraded to SP1 or SP2 to receive a hotfix. How will this work without SPs?
-
Q: Is the SQL Server lifecycle policy affected because there are no SPs any longer?
servicing lifecycle has not changed from SQL Server 2016 as it relates to mainstream and extended support.
A: No, the
References
-
KB 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
-
KB 3177534 How to obtain the latest SQL Server 2016 service pack
-
KB 2958069 How to obtain the latest SQL Server 2014 service pack
-
KB 2755533 How to obtain the latest SQL Server 2012 service pack
-
KB 2527041 How to obtain the latest SQL Server 2008 R2 service pack
-
KB 968382 How to obtain the latest SQL Server 2008 service pack
-
KB 321185 How to determine the version and edition of SQL Server and its components
-
The script to determine which version and edition of SQL Server Database Engine is running.
-
KB 957826 The builds for all SQL Server versions
-
KB 822499 Naming schema and Fix area descriptions for SQL Server software update packages
-
KB 824684 Description of the standard terminology that is used to describe Microsoft software updates