Home Dashboard Directory Help
Search

SQL Server 2008 Service Pack 2 by way0utwest


Status: 

Closed
 as External Help for as External


785
6
Sign in
to vote
Type: Suggestion
ID: 522123
Opened: 12/25/2009 3:55:30 PM
Access Restriction: Public
3
Workaround(s)
view

Description

When is SQL Server 2008 Service Pack 2 slated to be released? Many companies depend on these Service Packs to stay patched, being unwilling, and unable, to install CUs on a regular basis.
Details
Sign in to post a comment.
Posted by LRajgopal on 1/14/2011 at 8:18 PM
Hello, Does this apply even if SQL 2008 Enterprise Evaluation was upgraded to Developer edition? Some of the instruction says uninstall pre-release version of sql 2008...so this is bit confusing... Does this mean that developer edition needs to be uninstalled visual studio 2008 with sp1 installed and reinstall dev edition? Thanks R Lakshmi
Posted by Microsoft on 10/6/2010 at 2:06 PM
Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.

To download the SQL Server 2008 SP2 release please select from the links below:

SQL Server 2008 SP2: http://go.microsoft.com/fwlink/?LinkId=196550
SQL Server 2008 SP2 Express: http://go.microsoft.com/fwlink/?LinkId=196551
SQL Server 2008 SP2 Feature Packs: http://go.microsoft.com/fwlink/?LinkId=202815

Posted by Robert Breitenhofer on 9/30/2010 at 12:57 AM
Microsoft SQL Server 2008 Service Pack 2 -->

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17

|Version:10.00.4000.00|Date Published:9/29/2010|
Posted by Jon Morisi on 9/21/2010 at 11:10 AM
How close is this to being released? I've identified an issue that is resolved with SQL 2008 SP1 CU3, but would rather install SP2 if it will be out in a couple of weeks.

Thanks,
Jon
Posted by Prashant Thakwani on 9/14/2010 at 9:53 AM
Last i know is SQL Server 2008 SP2 is going to be released in Q3/2010. Is this still true ? We are in the last month of Q3/2010. What are the new dates if not Q3/2010 ?
Posted by Arnsen_Omninett on 7/12/2010 at 5:15 AM
MS released the community technology preview (CTP) version of SQL 2008 SP2 last week. Download link: http://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f&displaylang=en
Posted by Razvan Socol on 7/1/2010 at 7:21 AM
KB 2216474 says "To resolve this problem, obtain the latest service pack for SQL Server 2008. [...] This problem was first corrected in SQL Server 2008 Service Pack 2 for SQL Server 2008." However Service Pack 2 for SQL Server 2008 is not yet released. So we have a KB article about a fixed bug, no workarounds, but the fix is not yet available!
Posted by Debasis Sharma on 3/12/2010 at 1:10 PM
In reality I prefer Service Packs rather than cumulative updates. Hope fully SP2 will fix all those issues with SQL 2008.
Posted by jorgeghr on 2/23/2010 at 12:17 PM
This is very discouraging.
Posted by Rei on 2/21/2010 at 7:56 PM
If SQL 2008 R2 is scheduled for Q2 CY2010, why is SQL 2008 SP2 not going to be released at the same time? Arent there dependence between the two?
Posted by Valentino Vranken on 2/14/2010 at 11:49 PM
SQL Server 2008 SP2. Microsoft targets release in Q3/CY2010.

(http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/12/sql-server-servicing-plans.aspx)
Posted by Chris-CyberHostPro-Ltd on 2/8/2010 at 5:58 PM
does anyone know when SP2 for SQL 2008 is likely to be released??
Posted by AaronBertrand on 1/31/2010 at 8:19 AM
Chris, that was a typo and has been corrected.
Posted by ChrisAVWood on 1/27/2010 at 6:52 AM
Does this mean that an SP2 has been created http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0c51819b-3d40-435c-a103-a5481fe0a0d2&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MicrosoftDownloadCenter+%28Microsoft+Download+Center%29#tm

It mentions SQL2008 SP2 Enterprise Edition in the Overview.

Chris
Posted by RUNS on 1/26/2010 at 11:23 AM
i am interested to know about microsoft SQL Server 298 Express ( if not mistaken) because my lecturer wanted me to search for the information about this SQL server. i searched for many times in the internet about this SQL but unfortunately, i cant find any of the information. i really need the information of this SQL server 298 express. is'st exist in this SQL server or the name that i wrote was wrong? please kindly inform me to my emel = ctranieyah@yahoo.com.
Posted by saraho on 1/22/2010 at 12:54 AM
Come on guys, help us to help our clients and release the SP!
Posted by Stefbauer on 1/21/2010 at 12:49 PM
Is there a date yet for sp2?
Posted by jamome2 on 1/20/2010 at 12:06 PM
I am also looking forward to SQL 2008 SP2! My company recently upgraded from SQL 2005 to SQL 2008, thus we *won't* be upgrading to SQL 2008 R2 for a while.

Is there some sort of ballpark release date for SP2?
Posted by ShaneAlexander on 1/20/2010 at 2:30 AM
Yes please, SQL 2008 SP2!!!
Posted by Brettfavre on 1/19/2010 at 12:11 PM
SPs are so important to smaller shops that don't have full-time DBAs. Please make this a priority. SQL Server is a wonderful product for us little guys.
Posted by d.todd on 1/18/2010 at 5:36 PM
For us utilising older hardware as development servers, we can't go to SQL 2008 R2 in the short-term due to the cost of upgrading production and test and development environments.

So SP 2 is something we need.
Posted by swan-e on 1/17/2010 at 11:52 AM
SP2 would be a welcome release. Can anyone confirm the release schedule for these SP's?
Posted by Kevin Wagner on 1/16/2010 at 5:40 PM
Wait and upgrade to SQL 2008 R2. Way too many versions are being supported. Migrate to R2 and decomm SQL 2008 base.
Posted by Satya SKJ on 1/14/2010 at 9:47 AM
Get this before R2 release to make a strong foot of SQL2008 in the market,can't afford to wait. SPs are better managed than CU & hotfixes
Posted by Pinal Dave on 1/13/2010 at 10:58 PM
In industry I have been asked many times that when the SP2 of SQL Server 2008 is going to get released.

Many thanks!
Posted by Jacarezinho on 1/6/2010 at 10:13 AM
SQL Server 2008 SP2 urgent and immediately.
Posted by joeyfallon on 1/6/2010 at 1:09 AM
Service Pack please !
Posted by DB007 on 1/5/2010 at 2:10 AM
Service Packs are regression tested. CU Packs are not (just like hotfixs). Companies are very reluctant to deploy non-regression tested items into production unless absolutly essential. Please give us service packs !!.
Posted by percy.reyes on 1/4/2010 at 12:33 PM
SP2 for SQL Server 2008 is necessary,
Posted by Victor Amaya on 1/4/2010 at 12:15 PM
You should consider that there are several bugs related to viewing jobs steps when connecting to a SQL Server 2005, specially those related with SSIS. There are other errors related to the replication monitor and the activity monitor, where we can't see the current database of each connection
Posted by Chris Lively on 1/4/2010 at 8:16 AM
We use and apply all CUs. Typically about 2 weeks after they've been released and have been very happy with the results.

That said I would like to see one of two things: Either roll them up once every 6 months into a service pack; or, skip all service packs and just provide full testing prior to release of the CUs.
Posted by Greg M Palmes on 12/30/2009 at 6:47 AM
MSFT needs to STOP with these CU's and stick to fully tested SERVICE PACKS. Not just for SQL, but for all the products. It seems these days that's the bandaid approach for fixing all the bugs.

Too many bugs, too little fixes. The CU's seem to fix one thing and break another.
Posted by John Stafford at Lakeland on 12/30/2009 at 6:10 AM
There needs to be at least one more SP for SQL 2008 before people are pushed towards SQL 2008 R2 - in fact R2 should surely haev been teh next SP2, since you gain very little with Standard Edition!
Posted by sgf on 12/30/2009 at 5:17 AM
We do not rely on applying CU's as they are not fully tested which is stated by Microsoft. We do however rely on service packs. We stopped buying Seagate's reporting software years ago as they did not supply service packs.
Posted by EdVassie on 12/29/2009 at 3:02 AM
I would definitely like to see a SQL Server SP following the release of VS2010 and SQL Server 2008 R2 that includes all the compatibility updates needed for SQL Server 2008 to work with these products.
Posted by Drew Minkin on 12/28/2009 at 9:54 AM
SQL 2008 SP2 makes sense for a release around the same time SQL 2008 R2 ships. VS2010 support alone will require the SP in all likelihood.
Posted by RTango on 12/28/2009 at 6:27 AM
A couple of months back, we had issues with SSAS on SQL 2008 SP1 and had to install a CU to resolve the issue. I would really like to see the official service pack to be on a more stable version.
Posted by Craig Purnell on 12/28/2009 at 5:00 AM
Please release SP2 for SQL server 2008. We need more service packs and less CU's. there has to be a balance. Maybe a CU quarterly and a SP once a year.
Posted by jon-r on 12/27/2009 at 5:19 AM
Personally, I'd never apply a cumulative update unless absolutely necessary.
Our organisation has a carte blanche ban on applying CUs unless we fully test in a like-live environment for several weeks, as they're patches which past experience says are not fully tested.
I've been bitten so many times in the past that Service Packs are the only way to go.
Posted by Ivan Arjentinski on 12/27/2009 at 12:42 AM
SP2 is especially important now that the OPTION(RECOMPILE) bug has been resolved in SP1 CU5 - https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=452925
Posted by mondal303 on 12/26/2009 at 10:05 PM
Sql server 2008 SP2 is very much neccessary to fix the bugs which are still there in the product, we can't rely on cumulative updates and other hotfixes.
Sign in to post a workaround.
Posted by Robert Breitenhofer on 9/30/2010 at 1:00 AM
Microsoft SQL Server 2008 Service Pack 2 -->

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17

|Version:10.00.4000.00|Date Published:9/29/2010|
Posted by TM-naiman on 5/4/2010 at 7:36 PM
Thank
Posted by Debasis Sharma on 3/12/2010 at 1:09 PM
In reality I prefer Service Packs rather than cumulative updates. Hope fully SP2 will fix all those issues with SQL 2008.