SQL Server 2008 R2 Service Pack 1 Cumulative Update 11

By: Glenn Berry
Posted on: February 25, 2013 2:39 pm

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 1 Cumulative Update 11, which is Build 10.50.2869. There are only four fixes in the public fix list for this cumulative update. This cumulative update is only for SQL Server 2008 R2 Service Pack 1. If you have a different version and/or service pack of SQL Server installed, the cumulative update will not install or work.

This KB article (which is a handy reference to bookmark) has links to all of the cumulative updates for SQL Server 2008 R2 Service Pack 1:

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

Posted in: Cumulative Updates, Microsoft, SQL Server 2008 R2
Be the first to Reply!

SQL Server 2008 R2 Service Pack 2 Cumulative Update 5

By: Glenn Berry
Posted on: February 25, 2013 1:49 pm

On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 2 Cumulative Update 5, which is Build 10.50.4276. There are 21 fixes in the public fix list for this cumulative update, which is a pretty decent amount of fixes. This cumulative update is only for SQL Server 2008 R2 Service Pack 2. If you have a different version and/or service pack of SQL Server installed, the cumulative update will not install or work.

This KB article (which is a handy reference to bookmark) has links to all of the cumulative updates for SQL Server 2008 R2 Service Pack 2:

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

If you are running SQL Server 2008 R2, you should be on Service Pack 2 (at least in my humble opinion). If you are on SQL Server 2008 R2 Service Pack 2, you should make an effort to get the planning and testing infrastructure in place so that you can stay current with cumulative updates (rather than simply waiting for new service packs). I know that some organizations are completely against this philosophy, so I am going to make the case for my approach in an upcoming blog post.

Posted in: Cumulative Updates, Microsoft, SQL Server 2008 R2
Be the first to Reply!

SQL Server 2012 RTM Cumulative Update 6

By: Glenn Berry
Posted on: February 25, 2013 1:06 pm

On February 18, 2013 Microsoft released SQL Server 2012 RTM Cumulative Update 6, which is Build 11.0.2401. This CU has 22 fixes listed in the public fix list, which is quite a bit fewer hotfixes than in the first five cumulative updates for the RTM branch of SQL Server 2012. I take this as a sign that the SQL Server 2012 code base is becoming more stable, which is always a good thing.

This cumulative update is only for the RTM branch of SQL Server 2012. It will not install or work with SQL Server 2012 Service Pack 1 (or any other version or service pack level). The fixes in this cumulative update are not yet available in a cumulative update for SQL Server 2012 Service Pack 1. You will have to wait about a month for SQL Server 2012 Service Pack 1 CU3 to be released.

Microsoft has the RTM and Service Pack 1 branches of SQL Server 2012 out of synch as far as cumulative update releases are concerned, with the RTM branch being “ahead” of the Service Pack 1 branch. That means that if you have “done the right thing” by moving to SQL Server 2012 Service Pack 1, you have to wait about a month to reach parity with the RTM branch. Microsoft did not have this issue for SQL Server 2005, 2008, or 2008 R2 (except for a slight delay right after a new service pack was released), and they are not currently planning on fixing this issue (as far as I have been able to determine).

Posted in: Cumulative Updates, Microsoft, SQL Server 2012
Be the first to Reply!