|
How to perform an unattended upgrade of SQL Server 2008 R2 |
|
|
|
|
Written by Harry Zheng
|
|
Friday, 18 June 2010 21:27 |
-
Run setup.exe from a network location (installation directory).
-
Follow the wizard through to the Ready to Upgrade page. The path to the configuration file is specified in the Read to Upgrade page in the configuration file path section.
-
Cancel the setup without actually completing the installation, to generate the INI file.
-
Copy the ConfigurationFile.ini to the same folder of the installation directory.
-
Create a new file on the installation directory and name it upgrade.bat
-
Open upgrade.bat with Notepad and add the follow line: Setup.exe /ConfigurationFile=ConfigurationFile.ini
-
Open ConfigurationFile.ini with Notepad
-
Add this line to the beginning of the file after [SQLSERVER2008]: IAcceptSQLServerLicenseTerms="True"
-
Change QUIETSIMPLE="False" to QUIETSIMPLE="True"
-
Comment out this line: UIMODE="Normal" -> ;UIMODE="Normal"
-
Save all files.
-
Double click on upgrade.bat will launch the upgrade process.
Reference:
- http://msdn.microsoft.com/en-us/library/dd239405.aspx
- http://msdn.microsoft.com/en-us/library/ms144259.aspx
|
|
Last Updated on Saturday, 19 June 2010 12:06 |