Search results matching tags 'SQL Server 2008' and 'service pack 2'

July 2012 : Cumulative Updates for SQL Server 2008 are available

AaronBertrand — Tue, 17 Jul 2012 17:48:00 GMT

Today Microsoft has released two new cumulative updates for SQL Server 2008.

Cumulative Update #11 for SQL Server 2008 Service Pack 2

Knowledge Base Article: KB #2715951
At the time of writing, there are two fixes listed
The build number is 10.00.4333
Relevant for @@VERSION between 10.00.4000 and 10.00.4332

Cumulative Update #6 for SQL Server 2008 Service Pack 3

Knowledge Base Article: KB #2715953
At the time of writing, there are 14 fixes listed
The build number is 10.00.5788
Relevant for @@VERSION between 10.00.5500 and 10.00.5787

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

Cumulative Updates available for SQL Server 2008 SP2 & SP3

AaronBertrand — Mon, 21 May 2012 19:35:00 GMT

Today Microsoft has released two new cumulative updates for SQL Server 2008.

Cumulative Update #10 for SQL Server 2008 Service Pack 2

Knowledge Base Article: KB #2696625
At the time of writing, there is one fix listed
The build number is 10.00.4332

Cumulative Update #5 for SQL Server 2008 Service Pack 3

Knowledge Base Article: KB #2696626
At the time of writing, there are four fixes listed
The build number is 10.00.5785

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

SQL Server 2008 Cumulative Updates are available!

AaronBertrand — Tue, 20 Mar 2012 13:39:00 GMT

SQL Server 2008 Service Pack 2 Cumulative Update #9

KB article : http://support.microsoft.com/kb/2673382
Build number is 10.00.4330
7 fixes (5 in database engine, 2 in SSAS)
Relevant for : Builds of SQL Server between 10.00.4000 and 10.00.4329

SQL Server 2008 Service Pack 3 Cumulative Update #4

KB article : http://support.microsoft.com/kb/2673383
Build number is 10.00.5775
10 fixes listed
Relevant for : Builds of SQL Server between 10.00.5000 and 10.00.5774

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

New cumulative Updates for SQL Server 2008 SP2/SP3 are available!

AaronBertrand — Fri, 20 Jan 2012 16:07:00 GMT

On Monday, I completely missed that the SQL Server Release Services team published two cumulative updates for SQL Server 2008. I'd blame jury duty, but that didn't start until Tuesday, and only lasted two days. Well, better late than never.

Cumulative Update #8 for SQL Server 2008 Service Pack 2

KB : http://support.microsoft.com/kb/2648096
Build number : 10.00.4326
Number of fixes : 6
Relevant for : Builds of SQL Server where SELECT @@VERSION yields between 10.00.4000 and 10.00.4325

Cumulative Update #3 for SQL Server 2008 Service Pack 3

KB : http://support.microsoft.com/kb/2648098
Build number : 10.00.5770
Number of fixes : 14
Relevant for : Builds of SQL Server where SELECT @@VERSION yields between 10.00.5000 and 10.00.5769

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

P.S. this is blog post #499. You're probably not counting, but I am. :-)

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

This time it's for real - SQL Server 2008 Service Pack 2 is available!

AaronBertrand — Wed, 29 Sep 2010 16:52:00 GMT

I'm not going to blab about the speculation, or how Microsoft seems to like making their promised deadlines by the skin of their teeth. I'm too busy preparing how we're going to deploy and test SP2 on all of our SQL Server 2008 instances. So without any delay, here are the downloads / fix information:

Download Details: Microsoft SQL Server 2008 Service Pack 2
KB #2285068 : List of the bugs that are fixed in SQL Server 2008 Service Pack 2

As we've seen before, the release has been quietly posted to the downloads site and knowledge base with little fanfare, and there is not yet a post on the SQL Server Release Services blog. But I'm sure you'll hear more about it soon.

Note that the Service Pack only includes the fixes that were in SP1 CU 1 through 8. So if you have already applied CU9 or CU10, I would hold off on deploying the service pack for now, especially if you are relying on any of the fixes in either of those CUs - because there is a chance that you will lose them.

The service pack will patch any existing SQL Server 2008 instances (and client tools) on your machine, including Express instances (I seem to remember that you used to have to patch Express instances separately, with the whole Express setup program). Note that you can't patch client tools with a SQL Server 2008 Service Pack if you already have SQL Server 2008 R2 tools installed - this just means that the Shared Tools checkbox will be unavailable.

I know that some of you like to hear about the build numbers more than anything else. This service pack will move your build number to 10.0.4000:

Fellow SQL Server MVP Denis Gobo (blog | twitter) spoke about some of the changes introduced with Service Pack 2.

EDIT: And here are the announcements from the SQL Server Team Blog and SQL Server Release Services blog.

A SQL Server 2008 update is available - but it's not SP2

AaronBertrand — Wed, 22 Sep 2010 17:23:00 GMT

Last night Microsoft released Service Pack 1 Cumulative Update #10:

KB #2279604 : Cumulative update package 10 for SQL Server 2008 Service Pack 1

The build number is 10.00.2799 and there seem to be some interesting fixes included if you browse through them. But at least on first glance and at the gut level, I'm less interested in the fixes, and more interested in the timing. It seems very odd, given that - in response to customer demand - Service Pack 2 was promised in Q3 of this year, and Q3 ends in 8 days. And given also that typically another CU will need to be issued shortly after SP2 is released, in order to capture the fixes that branched off probably in July when the CTP of SP2 was first offered (I blogged about this as well).

The SQL Server Release Services blog has been oddly silent for a month (EDIT: they have pushed a post for this CU). Internal inquiries by several fellow MVPs have gone unanswered as well. At least one fellow twitterer feels more confident than I do that the release is imminent, but it begs the question, where is his information coming from?

Will we see Service Pack 2 by the end of Q3, or has the timeline slipped?

EDIT: I've already had a couple people ask if this update applies to R2, or if there is an equivalent update for R2 available at this time. This update is for SQL Server 2008 SP1 only. Cumulative Updates for SQL Server 2008 R2 have been released in conjunction with SQL Server 2005 SP3 CUs, so I don't expect that there will be a release for R2 so soon after the last one (mid-August). The next R2 CU should be made available around mid-October.