Despite the fact that end of mainstream support ended for SQL Server 2008 earlier this year, Microsoft have released SQL Server 2008 Service Pack 4. This arrives a few days after Service Pack 3 for SQL Server 2008 R2, but three years since the last one for this version of SQL. That’s a lot of updates!
- SQL Server 2008 R2 SP3 is available for download at the SQL Server 2008 SP4 download page.
- This service pack contains fixes from all 17 of the Cumulative Updates that were released since SP3 for SQL Server 2008, plus an on-demand update that was not part of a Cumulative Update. This is a huge number of fixes, nearly 3 years worth of patches, so make sure you test patching before you deploy them in a production environment.
- You must be running SQL Server 2008 SP3 in order to apply this update. You can download previous Service Packs here.
- Just like with SQL Server 2008 R2 SP2, support for SQL Server 2008 SP3 ends 13th October 2015, so really you want to install SP4 to extend support.
- For the latest service pack, support ends 12 months after the next service pack releases or at the end of the product’s support lifecycle, whichever comes first.
- The build number for SQL Server 2008 SP3 is 10.00.5500.00.
- The build for SP4 is 10.0.6000.29.
- Remember to download the correct version that you require as there are several version available depending on 32 bit/64 bit etc, and these service packs can be capacious, and you don’t want to waste bandwidth/time downloading the wrong one.
Service Pack 4 can be applied to any of the following Microsoft SQL Server 2008 editions:
- Microsoft SQL Server 2008 Enterprise
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 Express
- Microsoft SQL Server 2008 Standard
- Microsoft SQL Server 2008 Web
- Microsoft SQL Server 2008 Analysis Services
- Microsoft SQL Server 2008 Integration Services
- Microsoft SQL Server 2008 Reporting Services
You may have to restart the computer after you apply this cumulative update package.Follow @rPh0enix