Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to update Vista SP1 to SP2 and install SP1 for SQL Server Express 2008. In which order should I install these service packs and has anyone had any problems with installing SP1 for SQL Server 2008?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

Backup First

I'd strongly recommend backing your machine up before you apply either of those.

"Just in case!" (tm)

Once you have a backup in place, I believe you can apply the SQL patch first. It should tell you if your OS service pack level isn't high enough.

I know it does this for SQL 2000 server and 2005 as well. I'm not 100% positive on 2008.

Once again... if you have anything you value on that machine... please back it up first.

share|improve this answer
    
I tested it today and everything worked without any problems or warning messages. –  ZippyV Aug 27 '09 at 19:12
add comment

"... has anyone had any problems with installing SP1 for SQL Server 2008?" SP1 seems to install for many without too many hiccups. AFAIK it doesn't matter whether you install SP1 for Vista or SP1 for SQL 2008 first.

However...

There is one potential hiccup with the install: whether you have a pre-existing Visual Studio 2008 installation. If so, check out Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 and SQL 2008 SP1 installation confusion.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.