SQL Server 2008 R2 RTM Cumulative Update 9

Microsoft has released Cumulative Update 9 for SQL Server 2008 R2 RTM, which is Build 10.50.1804.0. I count 26 fixes in this Cumulative Update, which is for the RTM branch of SQL Server 2008 R2. Remember, this is completely separate from SQL Server 2008 SP2, which is the previous “major” version of SQL Server.

If you are still on the RTM branch of SQL Server 2008 R2, I would start thinking about and planning for how and when you are going move to the SP1 branch of SQL Server 2008 R2. You have some time, but at some point (probably in mid-2012), Microsoft is going to retire the RTM branch of SQL Server 2008 R2, which means that it will be considered an “unsupported service pack”. If you ever have to open a Support incident with Microsoft CSS, and they find out that you are on an “unsupported service pack” of SQL Server, they are not going to be able to give you the same level of support that you might expect…

Here is the current build chart for the two branches of SQL Server 2008 R2:

 

-- SQL Server 2008 R2 Builds                   SQL Server 2008 R2 SP1 Builds
-- Build            Description                Build         Description
-- 10.50.1092        August 2009 CTP2        
-- 10.50.1352        November 2009 CTP3
-- 10.50.1450        Release Candidate
-- 10.50.1600        RTM
-- 10.50.1702        RTM CU1
-- 10.50.1720        RTM CU2
-- 10.50.1734        RTM CU3
-- 10.50.1746        RTM CU4
-- 10.50.1753        RTM CU5
-- 10.50.1765        RTM CU6     --->           10.50.2500    SP1 RTM
-- 10.50.1777        RTM CU7
-- 10.50.1797        RTM CU8     --->           10.50.2769    SP1 CU1
-- 10.50.1804        RTM CU9     --->           10.50.2772    SP1 CU2
This entry was posted in Microsoft, SQL Server 2008 R2. Bookmark the permalink.

3 Responses to SQL Server 2008 R2 RTM Cumulative Update 9

  1. Naomi says:

    I’ve checked my build and it’s 1790 – it’s not listed here. The question is – what exactly I should install? Should I first install CU9 and then SP1 CU2?

    Thanks in advance.

  2. Glenn Berry says:

    Build 1790 is a security fix build that was pushed down from Microsoft Update. What I would do if I were you would be to install 2008 R2 SP1 (Build 2500), then install 2008 R2 SP1 CU2 (Build 2772). This will get you on the SP1 branch, with the latest CU.

  3. Naomi says:

    I installed SP1 last night, but got confused as which CU2 link I should get from the list of many links on that page. I have Windows 7 64 bit on a laptop.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s