Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQLServer 2008 SP 1 & 2

Posted on 2010-11-29
6
Medium Priority
?
603 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 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

579 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