How to update service pack in SQL Server 2008
I am a database developer and already have SQL Server 2008, Now I want to update to service pack 1. I am hitting the error: ?The setting ?PCUSOURCE? specified is not recognized. Do I need to use slipstream. Please help. Thanks in advance.
Hotfix update service pack in SQL Server 2008
If the SQL Server 2008 Setup support files are installed on the computer, you apply a CU or a hotfix to update the SQL Server 2008 Setup support files, and then rerun the Setup program from the DVD or the network share.To determine whether the SQL Server 2008 Setup support files are installed on the computer, view the entry by using Add or Remove Programs in Control Panel in operating systems that are earlier than Windows Vista. In Windows Vista or later versions of Windows, view the entry by using Programs and Features in Control Panel.
Limitations to update service pack in SQL Server 2008
There are some limitation for update service pack in SQL Server 2008. You must uninstall a failed installation if the Summary.txt log file indicates that you must uninstall and if you add features to an instance that already has the database service installed through slipstreaming, the installation may fail. To work around this issue, you need to add feature by using the original SQL Server 2008 source media or upgrade the instance to SP1 and then use the slipstream infrastructure.
Grand Theft Auto 4 PC Video Game
Use the slipstream procedure to update SQL Server 2008
Follow the following steps to create a slipstream drop that you can use for installing the original media and a service pack at the same time.
# Install the following prerequisites for SQL Server 2008.
.NET Framework 2.0 SP2 for SQL Server 2008 Express Edition
.NET Framework 3.5 SP1 for other edition
Windows Installer 4.5
# Download the service pack package that matches you system architecture. For example download the x64 package of SQL Server 2008 Service Pack 1 if your system is an x64-based system.
#Extract the service pack by running the following command:
# Run the service pack to install Setup files on the computer. You will receive a Setup Support Files dialog box if the Setup support files have not been installed. You can also run the following file to install the setup support files:
# Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:
The FIFA Manager 2009 PC Game
Update service pack in SQL Server 2008
These steps are for the English version of SQL Server 2008. However, it works for any language of SQL Server 2008 if you obtain the correct language of service pack package.
# Copy the original SQL Server 2008 source media to c:\SQLServer2008_FullSP1.
# Download the Service Pack 1 package. The package names are as follows:
# Extract the packages as follows:
Make sure that you complete this step for all architectures to ensure the original media is updated correctly.
#Run the following commands to copy the Setup.exe file and the Setup.rll file from the extracted location to the original source media location.
robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe
robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll
# Run the following commands to copy all files (not the folders), except the Microsoft.SQL.Chainer.PackageData.dll file, in C:\SQLServer2008_FullSP1\PCU\Architecture to C:\SQLServer2008_FullSP1 \Architecture to update the original files.
robocopy C:\SQLServer2008_FullSP1\pcu\x86 C:\SQLServer2008_FullSP1\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy C:\SQLServer2008_FullSP1\pcu\x64 C:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy C:\SQLServer2008_FullSP1\pcu\ia64 C:\SQLServer2008_FullSP1\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll
#Determine if you have the Defaultsetup.ini file in the following folders:
If you have the Defaultsetup.ini file in the folders, open the Defaultsetup.ini file, and then add PCUSOURCE=".\PCU" to the file
# Start the Setup program.
Update the SQL Server 2008 by SQLSupport.msi file
You can install the SQLSupport.msi file directly to your system but you must install the .NET Framework 3.5 SP1. Just double-click the hotfix package to install the SQL Server 2008 Setup support files. After you extract the contents of the package, the updated SQL Server 2008 Setup support files will be installed. The hotfix package will complete the installation without notifying you when it is completed. To confirm that the files are installed, view the entry by using the Add or Remove Programs item in Control Panel in operating systems that are earlier than Windows Vista. In Windows Vista or later versions of Windows, view the entry by using the Programs and Features item in Control Panel.
|Tags: kb968369 ia64 enuexe, kb968369 x64 enuexe, kb968369 x86 enuexe, net framework 35, slipstream, slipstream procedure, sql server 2008, sqlsupportmsi, update service pack, windows installer 45|
|Thread Tools||Search this Thread|
|Similar Threads for: "How to update service pack in SQL Server 2008"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Error Code 84C40007 with MS SQL Server 2008 Service Pack 2 (KB2285068)||Shazid||Operating Systems||3||21-02-2011 05:22 AM|
|Security Update for SQL Server 2005 Service Pack 2 (KB948109)||mizsub||Windows Update||16||16-10-2009 12:52 PM|
|Download SQL Server 2008 Service Pack 1||Sam.D||Windows Software||2||08-04-2009 01:16 PM|
|Download SQL Server 2008 Service Pack 1 - CTP released||Sam.D||Windows Software||2||24-02-2009 09:38 AM|
|Critical Update for SQL Server 2005 Service Pack 2 (KB 933508)||kusumanabh||Small Business Server||1||13-03-2007 11:56 PM|