Tuesday, September 1, 2009

How to: Install SQL Server 2008 SP1 from the Command Prompt

I just wanted to share how to install SQL Server 2008 Service Pack 1 from the command prompt.

This is a great guideline on How to: Install SQL Server 2008 from the Command Prompt. I was just missing the SP1 part.

So, you must download the SP1 installer from http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

Then, unzip its contents.

Then, use the following command:
setup.exe /QS /ACTION=Patch /AllInstances /IndicateProgress >> log-sql2008-sp1.txt

The ">> log-sql2008-sp1.txt" will give you a detailed installation log, just in case...

You've been upgraded to SP1. Hope this helps someone!


Jon Coulter said...

Thanks for the info. The /action=patch is not at all clear in docs (only shows install, uninstall, upgrade). Thanks a bunch!

tobingaa said...

Thanks, saved me a lot of time. I did this with SQL Server 2008 R2 to SQL Server 2008 R2 SP1, in this case you need 1 more parameter: /IAcceptSQLServerLicenseTerms

RealJohn said...

Great post, helped and worked. Thank you!

Anonymous said...

Hi, thanks for the post.

Another way you can do this is to download the SP1 executable and run this command:
SQLServer2008R2SP1-KB2528583-x64-ENU.exe /quiet /IAcceptSQLServerLicnseTerms /allinstances