![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Quick summary:
| RTM (no SP) | SP1 | SP2 | SP3 | SP4 | |
|---|---|---|---|---|---|
 SQL Server 2017codename vNext |
14.0.1000.169 *new |
||||
| SQL Server 2016 |
13.0.1601.5 | 13.0.4001.0 or 13.1.4001.0 |
13.0.5026.0 or 13.2.5026.0 |
||
| SQL Server 2014 |
12.0.2000.8 | 12.0.4100.1 or 12.1.4100.1 |
12.0.5000.0 or 12.2.5000.0 |
||
| SQL Server 2012 codename Denali |
11.0.2100.60 | 11.0.3000.0 or 11.1.3000.0 |
11.0.5058.0 or 11.2.5058.0 |
11.0.6020.0 or 11.3.6020.0 |
11.0.7001.0 or 11.4.7001.0 |
| SQL Server 2008 R2 codename Kilimanjaro |
10.50.1600.1 | 10.50.2500.0 or 10.51.2500.0 |
10.50.4000.0 or 10.52.4000.0 |
10.50.6000.34 or 10.53.6000.34 |
|
| SQL Server 2008 codename Katmai |
10.0.1600.22 | 10.0.2531.0 or 10.1.2531.0 |
10.0.4000.0 or 10.2.4000.0 |
10.0.5500.0 or 10.3.5500.0 |
10.0.6000.29 or 10.4.6000.29 |
| SQL Server 2005 codename Yukon |
9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
| SQL Server 2000 codename Shiloh |
8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| SQL Server 7.0 codename Sphinx |
7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
All SQLServer service packs are cumulative, meaning that each new service pack contains all the fixes that are included with previous service packs and any new fixes.
Legend:
| CTP | Community Technology Preview (beta release) |
| RC | Release Candidate |
| RTM | Released To Manufacturing; It is the original, released build version of the product, i.e. what you get on the DVD or when you download the ISO file from MSDN. |
| CU | Cumulative Update; Cumulative updates contain the bug fixes and enhancements–up to that point in time–that have been added since the previous Service Pack release and will be contained in the next service pack release. Installation of the Cumulative Update is similar to the installation of a Service Pack. Cumulative Updates are not fully regression tested. * Since January 27, 2016: Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available. SQL Server CUs are certified to the same levels as Service Packs, and should be installed with the same level of confidence. |
| SP | Service Pack; much larger collection of hotfixes that have been fully regression tested. In some cases delivers product enhancements. |
| GDR | General Distribution Release; GDR fixes should not contain any of the CU updates. |
| QFE | Quick Fix Engineering; QFE updates include CU fixes. |
| CVE | Common Vulnerabilities and Exposures; publicly known information-security vulnerabilities. |
Последние обновления, доступные для каждой версии SQL Server
Версия |
Последний пакет обновления (SP) |
Последний накопительный пакет обновления (CU) |
Полная информация о версии |
|---|---|---|---|
| SQL Server 2017 | Нет | CU4 для версии 2017 г.(14.0.3022.28 – февраль 2018 г.) | Сборки SQL Server 2017 |
| SQL Server 2016 | SQL Server 2016 SP1 (13.0.4001.0 – ноябрь 2016 г.) | CU7 для версии 2016 г. SP1(13.0.4466.4 – январь 2018 г.) CU9 для версии 2016 г. RTM(13.0.2216.0 – ноябрь 2017 г.) |
Сборки SQL Server 2016 |
| SQL Server 2014 | SQL Server 2014 SP2 (12.0.5546.0 – апрель 2017 г.) | CU10 для версии 2014 г. SP2 (12.0.5571.0 – январь 2018 г.) CU13 для версии 2014 г. SP1 (12.0.4522.0 – август 2017 г.) |
Сборки SQL Server 2014 |
| SQL Server 2012 | SQL Server 2012 SP4(11.0.7001.0 – сентябрь 2017 г.) |
CU10 для версии 2012 г. SP3 (11.0.6607.3 – август 2017 г.) CU16 для версии 2012 г. SP2 (11.0.5678.0 – сентябрь 2017 г.) CU16 для версии 2012 г. SP1 (11.0.3487.0 — май 2015 г.) |
Сборки SQL Server 2012 |
| SQL Server 2008 R2 | SQL Server 2008 R2 SP3(10.50.6000.34 – сентябрь 2014 г.) Примечание. Последний и окончательный выпуск для этой версии |
Нет | Сборки SQL Server 2008 R2 |
| SQL Server 2008 | SQL Server 2008 SP4(10.0.6000.29 – сентябрь 2014 г.) Примечание. Последний и окончательный выпуск для этой версии |
Нет | Сборки SQL Server 2008 |
| SQL Server 2005 | SQL Server 2005 SP4(9.00.5000.00 – декабрь 2010 г.) | Нет | Сборки SQL Server 2005 |
Примечание. «Последний» — выпущенный последним за прошедшие 12 месяцев.
Источники:
Сведения о жизненном цикле поддержки SQL Server
https://support.microsoft.com/ru-ru/lifecycle/search/?c2=1044
Microsoft SQL Server Version List
https://sqlserverbuilds.blogspot.com/
Как определить версию, выпуск и уровень обновления системы SQL Server и ее компонентов:
https://support.microsoft.com/ru-ru/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an
