sqlskills-logo-2015-white.png

Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

(New: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who ends up causing problems. Check them out here.)

As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014, I am very curious whether Microsoft is planning on releasing a SQL Server 2008 R2 Service Pack 3 or a SQL Server 2008 Service Pack 4 ?

SQL Server 2008 Service Pack 3 was released on October 25, 2011 , and we are now up to SQL Server 2008 SP3 CU15. SQL Server 2008 R2 Service Pack 2 was released on July 26, 2012, and we are now up to SQL Server 2008 R2 SP2 CU10.

I am not looking for release dates, just some word on whether there will be new Service Packs for SQL Server 2008 or SQL Server 2008 R2 before they both fall out of mainstream support this July.  Since many organizations still refuse to install Cumulative Updates, we have the very strong possibility of many customers running some very old builds of SQL Server 2008 and 2008 R2 going forward unless we get a final set of Service Packs for both versions.

As Paul Randal discovered in his recent survey, a very large percentage of SQL Server 2008 and 2008 R2 instances in the wild are already running on “unsupported service packs”, and this situation only got worse when SQL Server 2008 R2 SP1 fell out of support on October 8, 2013. These links show the builds that have been released since the most recent Service Packs for SQL Server 2008 and SQL Server 2008 R2.

The SQL Server 2008 Builds that were released after SQL Server 2008 Service Pack 3 was released

The SQL Server 2008 R2 Builds that were released after SQL Server 2008 R2 Service Pack 2 was released

If you want to try to influence Microsoft in some small way, please take a moment to up vote these Connect items. It only will take a few seconds to click the green arrow!

This is mine, meant to be a generic item:

https://connect.microsoft.com/SQLServer/feedback/details/814658/release-final-service-packs-for-sql-server-2008-and-2008-r2

This one is from Christoph Muthmann, for SQL Server 2008 SP3:

https://connect.microsoft.com/SQLServer/feedback/details/814600/release-service-pack-3-for-sql-server-2008-r2

This one is from Erland Sommarskog, regarding SQL Server 2012 SP2:

https://connect.microsoft.com/SQLServer/feedback/details/814656/release-service-pack-2-for-sql-server-2012

If you have a bit more time, write a comment in any of the Connect items.

8 thoughts on “Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

  1. It would be equally cool if they provided slipstreamed versions after each Service Pack – wishful thinking I suppose.

    I agree they need to get SP3 out for R2 – it’s long overdue.

    1. After mainstream support ends, there will be no more Service Packs or Cumulative Updates. Microsoft will still release security updates if any are necessary. You can still get support from Microsoft after mainstream support ends, but if your problem is caused by a code defect in SQL Server, Microsoft will not fix it, unless it is security related or you have paid them for extended support.

  2. I have spoken to our technical account manager at Microsoft and there are no plans at this stage for SQL2008 SP4. Nonetheless, we are going to “latest and greatest” at the moment = CU15 and I have voted for on your connect item. Seeing that slipstreaming for servicing is not available, this is the least they can do? 😉

    1. I don’t think they have made a final decision about SQL Server 2008 SP4. Hopefully, they will give in to popular opinion and release it. Any feedback they get about this is helpful. Thanks!

  3. My current client is performing a migration/upgrade next month…to SQL 2008 R2!

    M$ best release those service packs!

    S.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.