Search results matching tags 'hotfixes' and 'SQL Server 2012'

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)

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.

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

AaronBertrand — Thu, 24 Jan 2013 18:42:00 GMT

The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others.

KB article: KB #2790947
Build # is 11.0.3339
This build has FIFTY fixes!

There is also a KB article (KB #2792921) describing a couple of new features delivered with this cumulative update: enhancements to sysprep, and the ability to backup directly to Windows Azure Blob storage.

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

Cumulative Update #5 is available for SQL Server 2012 RTM

AaronBertrand — Tue, 18 Dec 2012 03:44:00 GMT

Microsoft has released Cumulative Update #5 for SQL Server 2012 RTM. Note this is *not* a cumulative update for Service Pack 1. So if your build # is >= 11.0.3000, you should not be installing this update.

KB Article: KB #2777772
Build # 11.0.2395
28 fixes at the time of writing

Looking for an update for the Service Pack 1 branch? You'll find that in January. For now at least, unlike the SQL Server 2008 R2 SP1/SP2 branches (which are in sync), the release cycles for SQL Server 2012 CUs will alternate - RTM one month, SP1 the next. This is mainly due to the out-of-band release of SP1 CU1 to get it caught up the the RTM CUs.

This update is only relevant for builds 11.0.2100 -> 11.0.3329. Do not attempt to install on SQL Server 2012 SP1 (any build >= 11.0.3000) or any previous version of SQL Server.

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

AaronBertrand — Tue, 20 Nov 2012 20:17:00 GMT

Waited to deploy SQL Server 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4? You're running out of reasons to procrastinate! The SQL Server team has released CU #1 for Service Pack 1, which should include all of the fixes from CU #3 & CU #4, as well as some others.

KB article: KB #2765331
Build # is 11.0.3321
I count a whopping 44 fixes!

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

SQL Server 2012 Service Pack 1 is available - this time for sure!

AaronBertrand — Thu, 15 Nov 2012 18:21:00 GMT

Last week I mentioned in passing that Service Pack 1 is now available, while I was blogging from the PASS Summit keynote. I wanted to put up an official post instead of having it appear as a footnote there (I also updated my April Fools' joke to point to the right place).

Service Pack 1 Details

Service Pack 1 is build # 11.0.3000 and includes 13 fixes to public KB items and 35 other internal (VSTS) items. You can see the list of fixes in KB #2674319.

You can also read about new features included in SP1 (well, first included in SP1 CTP4) on the Analysis Services team blog or in Books Online on MSDN.

You can download Service Pack 1 from the following URL:

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

A Caveat for Slipstreamers

The download page currently offers slipstreamed ISOs. However, another knowledge base article claims that, at least at the time of writing, these ISOs do not work. See more info in KB #2783963 - but for now I would suggest just downloading the standard SP1 installer (SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x86-ENU.exe). I haven't tested it, but you should still be able to build your own slipstream installs by combining these standard installers with your existing images, the "old-fashioned way."

Fixes from Cumulative Updates

Due to the length of time that goes into testing a Service Pack, SP1 includes only the updates from Cumulative Update #1 (11.0.2316) and Cumulative Update #2 (11.0.2325). So if you are relying on updates from Cumulative Update #3 (11.0.2332) or Cumulative Update #4 (11.0.2383), you may want to hold off on Service Pack 1 until the first post-SP1 Cumulative Update is available. Typically this is advanced so that you're not waiting an entire Cumulative Update cycle (~8 weeks), so I would expect it well before the end of the year.

Feature Pack

The SQL Server 2012 SP1 Feature Pack downloads are also available:

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

SQL Server 2012 Express Edition Service Pack 1

If you are looking for Express SP1, general web searches will probably lead you through a bunch of registration brouhaha - here is a direct link:

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

The most interesting thing about the Express release, to me, is that now the full version of Management Studio is completely free. The Express download page says that it includes Management Studio Express, but I have installed this, and it actually installs Management Studio proper with none of the limitations you are used to. Obviously some of the features that didn't exist before still don't make sense when you're only managing an Express instance (e.g. SQL Server Agent), but now you can use the free version of Management Studio to fully and properly manage all editions. Other tools such as Profiler and the Database Engine Tuning Advisor are now included also.

October 2012 Cumulative Updates are available - SQL Server 2008 R2 & SQL Server 2012

AaronBertrand — Tue, 16 Oct 2012 13:26:00 GMT

Microsoft released new cumulative updates for SQL Server; they announced them on their blog several hours ago.

SQL Server 2012 RTM Cumulative Update # 4

KB Article: KB #2758687
25 fixes are listed at the time of publication
Build number is 11.0.2383
Relevant for @@VERSION 11.0.2100 through 11.0.2382

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 9

KB Article: KB #2756574
14 fixes are listed at the time of publication
Build number is 10.50.2866
Relevant for @@VERSION 10.50.2500 through 10.50.2865

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 3

KB Article: KB #2754552
22 fixes are listed at time of publication
Build number is 10.50.4266
Relevant for @@VERSION 10.50.4000 through 10.50.4265

All fixes released after October 9th include the security updates from MS12-070.

MS12-070 : Security Updates for all supported versions of SQL Server

AaronBertrand — Wed, 10 Oct 2012 16:57:00 GMT

This week there was a security release for all supported versions of SQL Server. Each version has 32-bit and 64-bit patches, and each version has GDR (General Distribution Release) and QFE (Quick-Fix Engineering) patches. GDR should be applied if you are at the base (RTM or SP) build for your version, while QFE should be applied if you have installed any cumulative updates after the RTM or SP build. (More details here.)

SQL Server 2005

RTM, SP1, SP2, SP3 - not supported
SP4 - GDR = 9.00.5069, QFE = 9.00.5324

SQL Server 2008

RTM, SP1 - not supported
SP2 - GDR = 10.00.4067, QFE = 10.00.4371
SP3 - GDR = 10.00.5512, QFE = 10.00.5826

SQL Server 2008 R2

RTM - not supported
SP1 - GDR = 10.50.2550, QFE = 10.50.2861
SP2 - not affected

SQL Server 2012

RTM: GDR = 11.00.2218, QFE = 11.00.2376
SP1 - not yet supported; should not be affected once SP1 is released.

Now, a couple of oddities you might have noticed:

The security bulletin mentions something about SQL Server instances with Reporting Services installed. Yet the KB articles for individual updates state that all instances of SQL Server are eligible for the update. And the update does, in fact, update sqlservr.exe and @@VERSION, even for systems where SSRS is not installed. So until there is some clarification on this point, I'm going to treat this as a patch for all instances.
Both the GDR and QFE KBs for multiple patches state that the preceding cumulative updates are included. I believe this is a copy & paste error and that the cumulative updates for a specific branch are only included with the QFE patch. I will update here if I get any confirmation on this.

Even if they come back and say, whoops, our bad, the KBs should mention it is SSRS only, and the GDRs do not affect sqlservr.exe and do not include the CU updates, I'm still going to apply the patch everywhere. Why? Well, for consistency, I'd rather have all of my instances at @@VERSION = x, than have the SSRS instances at x and the non-SSRS instances at < x.

SQL Server 2012 Cumulative Update #1 is available!

AaronBertrand — Thu, 12 Apr 2012 15:28:00 GMT

While I joked earlier this month that SQL Server 2012 Service Pack 1 was released on the same day as General Availability (hey, it's Microsoft's fault since they decided to GA on April 1), this time it isn't a joke. Today Microsoft has released Cumulative Update #1 for SQL Server 2012. About half of the fixes affect the database engine. Analysis Services and Data Quality Services make up the bulk of the remainder. If you're running SQL Server 2012 now, I suggest you apply the update. This would also be a good opportunity to test the slipstream functionality in setup, to see if it automatically pulls in the CU #1 update for new installs (I'm on vacation so will try that out next week).

I've seen many people insist that they will not even think about deploying SQL Server 2012 until Service Pack 1 is available. In CU #1 there are 55 fixes currently listed, but most affect SQL Server 2008 R2 as well, so these are not issues that have anything to do with pre-SP1 jitters. But I guess some will continue to lock themselves into this old wives' tale that no software publisher could ever produce RTM code that is stable enough for prime time.

Note that some of these fixes that affect both 2012 and earlier platforms won't be available for SQL Server 2008 R2 until the next cumulative updates are released for those branches, which should be within the next two weeks (and for 2008, about 6 weeks). Though based on the code freeze for an RTM vs. a CU I suspect that some of the fixes just released for SQL Server 2012 are already in place for the earlier versions. It would be tedious to do a fix-by-fix comparison but, now that I've alluded to it, I'll probably end up doing it at some point.

The build number for SQL Server 2012 CU #1 is 11.0.2316, and you can see the following KB article:

http://support.microsoft.com/kb/2679368

I'll update this space when I have more information.

NOTE: If you are using Data Quality Services (DQS), please see Greg Low's blog post.