Search results matching tag 'SP1'

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

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

SQL Server 2012 Service Pack 1 CTP4 is available

AaronBertrand — Thu, 20 Sep 2012 18:28:00 GMT

This morning the SQL Server team announced the release of Service Pack 1 CTP4 for SQL Server 2012. Back in July I talked about CTP3 and how the release contained BI features only; no fixes. The newer CTP does have fixes and other engine enhancements as well; there is even proper documentation in Books Online about the enhancements. The download page also lists them:

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

The build # is 11.0.2845. There are 37 fixes listed in the knowledge base article, KB #2674317 (but it's possible that number will change before RTM). Many of these fixes are ones that were included in RTM CU#1 and CU#2. No fixes from CU#3 are currently present in the SP1 CTP.

New cumulative updates for SQL Server 2008 R2 (RTM & SP1) are available!

AaronBertrand — Tue, 17 Apr 2012 12:06:00 GMT

This morning the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2.

Cumulative Update #13 for SQL Server 2008 R2 RTM

Knowledge Base article: http://support.microsoft.com/kb/2679366
Build number: 10.50.1815
Number of fixes: 9
Relevant for builds of SQL Server between 10.50.1600 and 10.50.1814

Cumulative Update #6 for SQL Server 2008 R2 Service Pack 1

Knowledge Base article: http://support.microsoft.com/kb/2679367
Build number: 10.50.2811
Number of fixes: 20
Relevant for builds of SQL Server between 10.50.2500 and 10.50.2810

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 (where @@VERSION will report 10.00.xxxx).

Two new cumulative updates for SQL Server 2008 R2 are available!

AaronBertrand — Thu, 23 Feb 2012 15:23:00 GMT

Last night Microsoft released two new cumulative updates for SQL Server 2008 R2:

Cumulative Update 5 for SQL Server 2008 R2 SP1

KB #2659694
Build 10.50.2806
16 fixes, including a nasty SCOPE_IDENTITY() bug and several performance fixes.

My recommendation: You should test and plan for this update if SELECT @@VERSION is between 10.50.2500 and 10.50.2805.

Cumulative Update 12 for SQL Server 2008 R2 (RTM)

KB #2659692
Build 10.50.1810
3 fixes but none are directly related to the relational engine.

My recommendation: Consider applying if SELECT @@VERSION is between 10.50.1600 and 10.50.1809, you are affected by any of the issues highlighted in the KB article, and you are avoiding Service Pack 1 intentionally (otherwise you should install SP1 and CU5 for SP1).

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

New cumulative updates for SQL Server 2008 R2 are available!

AaronBertrand — Tue, 20 Dec 2011 15:18:00 GMT

Microsoft has just released cumulative updates for both SQL Server 2008 R2 branches - RTM and Service Pack 1.

SQL Server 2008 R2 Service Pack 1 Cumulative Update #4

http://support.microsoft.com/kb/2633146/
Build number is 10.50.2796
Contains 53 fixes (as of February 6, 2012)

SQL Server 2008 R2 RTM Cumulative Update #11

http://support.microsoft.com/kb/2633145/
Build number is 10.50.1809
Contains 23 fixes (as of February 6, 2012)

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 (where @@VERSION will report 10.00.xxxx).

Cumulative Updates for SQL Server 2008 R2 are available!

AaronBertrand — Mon, 17 Oct 2011 23:57:00 GMT

Today Microsoft has released Cumulative Updates for SQL Server 2008 R2.

Cumulative Update #10 for SQL Server 2008 R2 RTM

Build number: 10.50.1807
KB article: KB #2591746
13 fixes

Cumulative Update #3 for SQL Server 2008 R2 Service Pack 1

Build number: 10.50.2789
KB article: KB #2591748
22 fixes

Please note: these updates are for SQL Server 2008 R2 only - not for the original SQL Server 2008 release (regardless of service pack level).

SQL Server 2008 R2 Service Pack 1 is now available

AaronBertrand — Tue, 12 Jul 2011 13:52:00 GMT

And the hits keep coming! Microsoft not only released Denali CTP3 today, they have also released Service Pack 1 for SQL Server 2008 R2, which was first released as a CTP back in April (build 10.50.2425). If you installed the CTP, SELECT @@VERSION will yield something similar to the following:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2425.0 (X64) 
    Apr  6 2011 21:03:25 
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

[Note that checking SERVERPROPERTY('ProductLevel') will tell you this is Service Pack 1, even though it is not the final release - so you'll need to rely on the build numbers furnished by @@VERSION or SERVERPROPERTY('ProductVersion') when trying to determine if you have the final release of SP1.]

Now the code is officially released, and you can download the service pack from the Download Center:

http://www.microsoft.com/download/en/details.aspx?id=26727

If you're looking for SP1 for SQL Server Express:

http://www.microsoft.com/download/en/details.aspx?id=26729

And the updated feature packs can be found here:

http://www.microsoft.com/download/en/details.aspx?id=26728

The build number is 10.50.2500. SELECT @@VERSION will now yield something like this:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) 
    Jun 17 2011 00:54:03 
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

You can read about some of the changes in Service Pack 1 (no, it is not just a bunch of fixes) in these blog posts:

SQL Server 2008 R2 SP1 CTP is now available

More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP

And you can read about the fixes that are included by reading KB #2463333:

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

...and by investigating the fixes in each of the first 6 cumulative update packages (they won't all be listed in the KB above):

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

As described in the following blog post from the Release Services team, Service Pack 1 does not include the fixes from Cumulative Update 7 or Cumulative Update 8:

http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/06/21/cumulative-updates-included-in-sql-server-2008-r2-sp1.aspx

UPDATE : I have confirmed that the security update from June's Patch Tuesday (which I discussed here and here) is included in the service pack.

The release notes are here:

http://social.technet.microsoft.com/wiki/contents/articles/microsoft-sql-server-2008-r2-sp1-release-notes.aspx

And no, this service pack is not for SQL Server 2008, it is ONLY for SQL Server 2008 R2. I'm still baffled by how many people think these are the same overall version - and I curse Microsoft for their naming choice. I sincerely hope they've learned a valuable lesson from this...