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?
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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

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.

Question has a verified solution.

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

Suggested Solutions

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 …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 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