patternsqlMinor
SQL Server Version - are hotfixes for previous versions implied?
Viewed 0 times
previoussqlversionhotfixesareimpliedforversionsserver
Problem
tl;dr: If I identify an SQL Server as having build X, and find out that X implies hotfix Y, does it also imply that all hotfixes listed for versions below X are installed? Or that only the hotfix for build X is installed?
I found the following list of Microsoft SQL Server version numbers and their meaning in terms of service packs, hotfixes, product versions, etc.:
My question is best illustrated with an example, an excerpt from that list:
In the above list, if I find out that the SQL Server I am connected to is version 1502, does this imply that:
ie. does the build imply that all previous hotfixes are installed?
Follow-up bonus question: Is this a fixed pattern for all the versions, or are there exceptions to the rule?
I found the following list of Microsoft SQL Server version numbers and their meaning in terms of service packs, hotfixes, product versions, etc.:
- SQL Server Version Database @ sqlsecurity.com
My question is best illustrated with an example, an excerpt from that list:
2005 RTM+Q915793 9.00.1502 <-- interested in this
2005 RTM+Q910416 9.00.1500
2005 RTM+Q932557 9.00.1406In the above list, if I find out that the SQL Server I am connected to is version 1502, does this imply that:
- only hot-fix Q915793 is installed?
- or that all of hot-fixes Q915793, Q910416 and Q932557 are installed?
ie. does the build imply that all previous hotfixes are installed?
Follow-up bonus question: Is this a fixed pattern for all the versions, or are there exceptions to the rule?
Solution
All hotfixes are cumulative unless otherwise stated.
Random pick, http://support.microsoft.com/?Kbid=971409
Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix.
The "otherwise stated" is like these examples where you have some dependencies (sorry. bit old, for SQL Server 2000 and SP4). http://support.microsoft.com/?Kbid=941203 and http://support.microsoft.com/kb/959420
Random pick, http://support.microsoft.com/?Kbid=971409
Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix.
The "otherwise stated" is like these examples where you have some dependencies (sorry. bit old, for SQL Server 2000 and SP4). http://support.microsoft.com/?Kbid=941203 and http://support.microsoft.com/kb/959420
Context
StackExchange Database Administrators Q#4218, answer score: 6
Revisions (0)
No revisions yet.