Search results matching tags 'patches' and 'SP2'

April 2013 Cumulative Updates for SQL Server 2008 R2

AaronBertrand — Mon, 15 Apr 2013 18:00:00 GMT

Today Microsoft released new cumulative updates for SQL Server 2008 R2.

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12

KB Article: KB #2828727
7 fixes listed at time of publication
Build number is 10.50.2874
Relevant for @@VERSION 10.50.2500 through 10.50.2873

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 6

KB Article: KB #2830140
13 fixes listed at time of publication
Build number is 10.50.4279
Relevant for @@VERSION 10.50.4000 through 10.50.4278

My usual disclaimer: these updates are NOT for SQL Server 2008 (or SQL Server 2012). Only apply to systems where SELECT @@VERSION returns 10.50.xxxx, where xxxx is >= 2500. If xxxx < 2500, you need to start thinking about getting off the RTM branch. And based on the number of fixes making it into the SP2 updates, you might consider abandoning SP1, too, if possible...

SQL Server 2008 R2 Service Pack 2 Cumulative Update #1 is available

AaronBertrand — Wed, 01 Aug 2012 19:23:00 GMT

Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week.

KB article is http://support.microsoft.com/kb/2720425
Build number is 10.50.4260.0
There are 35 fixes published as of 2012-08-01
This update is relevant for builds between 10.50.4000 and 10.50.4259

My recommendation: if you have already installed Service Pack 2, or were waiting on the first cumulative update before doing so, this may be what you've been waiting for. According to the SQL Release Services Blog, SP2 CU#1 includes all of the fixes from SP1 CU#6 and CU#7 (which were not included in SP2 RTM).

My usual disclaimer: these updates are NOT for SQL Server 2008. Only apply to systems where @@VERSION returns 10.50.xxxx, where xxxx is >= 4000.

SQL Server 2008 R2 Service Pack 2 CTP is available

AaronBertrand — Mon, 14 May 2012 18:23:00 GMT

You can download the Service Pack 2 CTP from the following URL:

http://www.microsoft.com/en-us/download/details.aspx?id=29848

The build # is 10.50.3720. This service pack contains all of the fixes from Service Pack 1 & Cumulative Updates 1 through 5, and a couple of other minor fixes (a couple of SSRS bugs and a bug about an ALTER TABLE batch not being cached correctly). It does not include fixes from Service Pack 1 Cumulative Update #6, which I mentioned recently.

You should *NOT* install this service pack preview if:

your build number (SELECT @@VERSION;) is 10.00.xxxx (since this is SQL Server 2008, not SQL Server 2008 R2);
your build number is >= 10.50.1815 and < 10.50.2500 (since you may be undoing fixes you are using from RTM CU13); or,
your build number is >= 10.50.2811 (since you will be undoing fixes you might be using from SP1 CU6).