SQLServer 2008 SP 1 & 2

Posted on 2010-11-29
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.
Question by:ksfok
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
LVL 57

Accepted Solution

Raja Jegan R earned 375 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
LVL 13

Assisted Solution

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

Author Comment

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?
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

LVL 57

Assisted Solution

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

Author Comment

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

Assisted Solution

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

instead of doing it via Windows Update..

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
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.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

740 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