Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQLServer 2008 SP 1 & 2

Posted on 2010-11-29
6
Medium Priority
?
600 Views
Last Modified: 2012-05-10
I have installed Sql Server 2008 dev on my dev laptop a few months ago. I don't remember if I have installed SP1. Today as I ran Windows Update, I saw SP2 as optional update. Can I go ahead install SP2 without checking and installing SP1 first? Please advise.
Thanks.
0
Comment
Question by:ksfok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 1500 total points
ID: 34235839
yes, you can go ahead by instaling SQL Server 2008 SP2.
Its advised to stay upto date with Latest Service packs for SQL Server..

>> Can I go ahead install SP2 without checking and installing SP1 first?

Since SP2 is cumulative, installing SP2 would install all of the updates contained in SP1
0
 
LVL 13

Assisted Solution

by:themrrobert
themrrobert earned 500 total points
ID: 34235840
SP2 Will automatically install SP1 if its not already installed
0
 

Author Comment

by:ksfok
ID: 34235866
I accidentally closed off the browser during the install, then reran the operation. Now I am seeing the install percentage incrementing. Is it OK?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1500 total points
ID: 34235880
Ok, SP2 installation should go on without any issues..
0
 

Author Comment

by:ksfok
ID: 34235881
The downloading appears to be painfully slow. Can I abort it now and do it over again later?
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1500 total points
ID: 34235889
Or else, you can download it from here

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

instead of doing it via Windows Update..
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question