Search results matching tags 'hotfixes' and 'Service Pack 1'

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

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.

Cumulative Update #2 for SQL Server 2008 R2 SP1 is available

AaronBertrand — Tue, 16 Aug 2011 14:47:00 GMT

Last night Microsoft has released Cumulative Update #2 for SQL Server 2008 R2 Service Pack 1. The build # is 10.50.2772 and it contains 14 fixes, a few of which are wrong-results bugs or cases of access violations.

You can download the update here:

KB #2567714 : Cumulative update package 2 for SQL Server 2008 R2 Service Pack 1

It was also mentioned on the SQL Server Release Services blog. It seems to be implied that some of these fixes were included in CUs 7 or 8 for RTM but were left out of SP1 and SP1 CU1, but I haven't validated that by performing a diff.

My necessary disclaimer these days: This update is NOT for SQL Server 2008, and it is NOT for SQL Server 2008 R2 RTM.

New cumulative updates for SQL Server 2008 SP1 & SP2 are available!

AaronBertrand — Mon, 18 Jul 2011 21:28:00 GMT

In addition to SQL Server 2008 R2 SP1 CU1, Microsoft today also released cumulative updates for the SQL Server2008 branches (Service Pack 1 and Service Pack 2). You can download these updates from the following KB articles:

KB #2555406 : Cumulative update package 15 for SQL Server 2008 Service Pack 1
(Build number = 10.00.2847)

KB #2555408 : Cumulative update package 5 for SQL Server 2008 Service Pack 2
(Build number = 10.00.4316)

Slipstreaming

And if you want to slipstream one of these CUs with its associated base service pack, you can follow Peter Saddow's instructions here (the specific file names are different, but the concept is exactly the same):

http://blogs.msdn.com/b/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server-pack-1.aspx

To be clear...

As a reminder, these cumulative updates are only for SQL Server 2008 SP1 (10.00.2531 -> 10.00.2846) and SP2 (10.00.4000 -> 10.00.4315), not for SQL Server 2008 RTM (10.00.anything less than 2531) or for SQL Server 2008 R2 (version 10.50.anything).

SQL Server 2008 R2 SP1 CU1 is now available!

AaronBertrand — Mon, 18 Jul 2011 19:33:00 GMT

For those of you that held out on installing SQL Server 2008 R2 Service Pack 1 because it was missing the fixes from RTM's Cumulative Updates 7 & 8, your wait is over - CU1 is here and it contains these fixes. I didn't verify this for every fix individually, but this is supposed to be the goal, so I'm going to take a leap of faith here. You can download the CU here (and you can read about the rest of SP1 in a previous blog post):

KB #2544793 : Cumulative update package 1 for SQL Server 2008 R2 Service Pack 1

The build number is 10.50.2769.

Slipstreaming

Here is Peter Saddow's advice on slipstreaming Service Pack 1 into the RTM binaries:

http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx

And you can follow his steps for combining SP1 + CU1 for SQL Server 2008 - the process is largely the same:

http://blogs.msdn.com/b/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server-pack-1.aspx

A Reminder

And once again, just to be clear, this Cumulative Update is for SQL Server 2008 R2 SP1, not for SQL Server 2008 R2 RTM (build # < 10.50.2425) and not for SQL Server 2008 (build number 10.00.anything). Note that Microsoft did also release cumulative updates for SQL Server 2008 SP1 & SP2 today.

Cumulative Update #7 for SQL Server 2008 R2 is available

AaronBertrand — Mon, 18 Apr 2011 18:22:00 GMT

Many of you are probably asking, "Where is Service Pack 1 already?" Patience, friends. It will come in due time. In the meantime, you can see if any of the fixes in CU7 for RTM are applicable to symptoms you are experiencing (there are 33 fixes in total, so look carefully):

KB #2507770 : Cumulative Update #7 for SQL Server 2008 R2

The build number for CU #7 is 10.50.1777.