Solved

SQLServer 2008 SP 1 & 2

Posted on 2010-11-29
6
585 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
  • 3
  • 2
6 Comments
 
LVL 57

Accepted Solution

by:
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
0
 
LVL 13

Assisted Solution

by:themrrobert
themrrobert earned 125 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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…
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now