Search results matching tag 'patches'

SQL Server 2012 RTM Cumulative Update #8 is available!

AaronBertrand — Tue, 18 Jun 2013 16:12:00 GMT

The SQL Server team has released CU #8 for SQL Server 2012 RTM.

KB article: http://support.microsoft.com/kb/2844205
Build # is 11.0.2410
This build has 6 fixes

Relevant for builds 11.0.2100 -> 11.0.2409. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version.

June 2013 Cumulative Updates for SQL Server 2008 R2

AaronBertrand — Mon, 17 Jun 2013 19:31:00 GMT

Well, surely at least partly in response to the CU6 mess I reported earlier today, and partly because they were due, Microsoft has released new cumulative updates that contain - among other things - updated code that avoids the symptom introduced with earlier updates (though this regression fix doesn't seem to appear in the KB articles - unless by "corruption" they meant ridiculous size increase).

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 13

KB Article: KB #2855792
5 fixes listed at time of publication
Build number is 10.50.2876
Relevant for @@VERSION 10.50.2500 through 10.50.2875

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 7

KB Article: KB #2844090
11 fixes listed at time of publication
Build number is 10.50.4286
Relevant for @@VERSION 10.50.4000 through 10.50.4285

(Also see KB #2792921 for information on new features in the SP2 CU7 release.)

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...

Attention users running SQL Server 2008 & 2008 R2!

AaronBertrand — Mon, 17 Jun 2013 17:23:00 GMT

In April and May, Microsoft released cumulative updates for SQL Server 2008 and 2008 R2 (I blogged about them here and here). They are:

CU #11 for 2008 SP3 (10.00.5840) (KB #2834048)
CU #12 for 2008 R2 SP1 (10.50.2874) (KB #2828727)
CU #6 for 2008 R2 SP2 (10.50.4279) (KB #2830140)

Sometime after that, looks like the next day, both downloads were pulled, allegedly due to an index corruption issue (if you believe the commentary on the Release Services blog post for CU #6) or due to an issue with w3wp.exe (if you believe the label on the hotfix posted directly to the CU #6 article itself). Or perhaps both. At the very least you may see a regression involving index corruption when you rebuild a clustered index online and the plan involves a non-clustered index. I don't have a repro handy.

On June 13th, both articles were updated with new versions of the cumulative updates that no longer exhibit this symptom (sound familiar?). So if you download today, you'll actually get:

CU #11 for 2008 SP3 (10.00.5841) (KB #2834048)
CU #12 for 2008 R2 SP1 (10.50.2875) (KB #2828727)
CU #6 for 2008 R2 SP2 (10.50.4285) (KB #2830140)

Please check @@VERSION. If it reports 10.00.5840, 10.50.2874 or 10.50.4279, please go re-download and re-apply the relevant cumulative update for your branch. If you're on 2008 R2, please see my post where I announce new CUs for the 2008 R2 branches.

In cases like this, I really, really, really wish they would release a new, out-of-band cumulative update (this is a non-issue, now, for R2, but remains an issue for 2008 SP3 customers for another month or so). How many people go back and take another look at the CU article once they have downloaded, installed, and regression tested? Does everyone regression test a full set of online rebuilds that probably don't occur that often? I think many users will simply not see this update and are on the verge of experiencing the symptom - there simply isn't enough visibility when they quietly swap out the versions that the download links yield.

[Cross-posted on sqlperformance.com]

SQL Server 2012 Service Pack 1 Cumulative Update #4 is available!

AaronBertrand — Sat, 01 Jun 2013 16:56:00 GMT

The SQL Server team has released CU #4 for Service Pack 1.

KB article: KB #2833645
Build # is 11.0.3368
This build has 39 fixes by my count.

For more information about this cumulative update, see the following posts:

SQL Release Services Blog : Cumulative Update #4 for SQL Server 2012 SP1

SQLOS Team Blog : Enhancements to SQL Server Backup to Cloud in SQL Server 2012 SP1 CU4

KB #2792921 : Description of new features in Cumulative Update 4 for SQL Server 2012 SP1

Relevant for builds 11.0.3000 -> 11.0.3367. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.

May 2013 Cumulative Update for SQL Server 2008 SP3

AaronBertrand — Tue, 21 May 2013 12:14:00 GMT

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #11

Build # 10.00.5840
KB Article: KB #2834048
6 fixes
Relevant for builds 10.00.5500 -> 10.00.5839
NOT for SQL Server 2008 R2 (10.50.xxxx)

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

SQL Server 2012 Cumulative Update #7 is available!

AaronBertrand — Mon, 15 Apr 2013 12:45:00 GMT

The SQL Server team has released CU #7 for SQL Server 2012 RTM.

KB article: http://support.microsoft.com/kb/2823247
Build # is 11.0.2405
This build has 17 fixes

Relevant for builds 11.0.2100 -> 11.0.2404. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version.

March 2013 Cumulative Updates - SQL Server 2012 SP1 & 2008 SP3

AaronBertrand — Mon, 18 Mar 2013 21:40:00 GMT

SQL Server 2012 Service Pack 1 Cumulative Update #3

Build # 11.0.3349
KB Article: KB #2812412
38 fixes!
Relevant for builds 11.0.3000 -> 11.0.3348
NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)

SQL Server 2008 Service Pack 3 Cumulative Update #10

Build # 10.00.5835
KB Article: KB #2814783
8 fixes
Relevant for builds 10.00.5500 -> 10.00.5834
NOT for SQL Server 2008 R2 (10.50.xxxx)

February 2013 Cumulative Updates for SQL Server 2008 R2

AaronBertrand — Mon, 18 Feb 2013 19:00:00 GMT

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

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11

KB Article: KB #2812683
4 fixes listed at time of publication
Build number is 10.50.2869
Relevant for @@VERSION 10.50.2500 through 10.50.2868

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 5

KB Article: KB #2797460
21 fixes listed at time of publication
Build number is 10.50.4276
Relevant for @@VERSION 10.50.4000 through 10.50.4275

SQL Server 2012 RTM Cumulative Update #6 is available!

AaronBertrand — Mon, 18 Feb 2013 18:49:00 GMT

The SQL Server team has released CU #6 for SQL Server 2012 RTM.

KB article: http://support.microsoft.com/kb/2728897
Build # is 11.0.2401
This build has 22 fixes

Relevant for builds 11.0.2100 -> 11.0.2400. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version.