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

Hi,
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!

How to perform an unattended install of Visual Studio 2008

This file explains all about how to perform an unattended install of Visual Studio 2008
http://go.microsoft.com/fwlink/?LinkID=101063

Want a summary? This is my 3 step guide. Hope it helps!

1. Create a INI file that contains the configuration you desire with this command:

[VISUAL STUDIO SETUP FOLDER]\setup\Setup.exe /createunattend [PATH TO INI FILE TO BE CREATED]

Run the setup UI and at the end you'll get a "Save settings button".

2. Then, modify the INI FILE this way:

Locate and remove "gfn_mid windows installer 3.1" lines in [PreInstallOrder], [InstallOrder], and [PostInstallOrder] sections of the file.

3. Run the unattended installation:

[VISUAL STUDIO SETUP FORLDER]\setup\Setup.exe /unattendfile [PATH TO INI FILE]

Also, important to know:

Visual Studio Log File Locations

The following log files are generated during Visual Studio 2008 setup:

* dd_error__90.txt
* dd_install__90.txt
* VSMsiLog****.txt (where * is a randomly-generated suffix)

During Visual Studio setup , the log files are located in the %temp% directory. For example:

C:\Documents and Settings\[User Name]\Local Settings\Temp

After Visual Studio installation , the log files are located in the Logs directory in the path that Visual Studio is installed. For example:

C:\Program Files\Microsoft Visual Studio 9\[Product Name]\Logs

After a Visual Studio failed installation or removal, the log files are left in the %temp% directory.