This article describes how to update or slipstream a failed installation of Microsoft SQL Server 2008 by using the latest Cumulative Update (CU) or latest Service Pack (SP). Use these instructions when you cannot install SQL Server 2008 because of a known issue in the Setup program. The "SQL Server 2008 Setup hotfixes" section lists the Microsoft Knowledge Base articles that describe known setup issues and explains how to obtain the latest update.
There are two situations to consider:
For answers to frequently asked questions about slipstreaming, see the SQL Server 2008 Slipstream Frequently Asked Questionstopic on the following Microsoft Web site:
There are two situations to consider:
- You attempt to install SQL Server 2008. You encounter a setup failure, and the setup files are installed on the computer.
- You want to proactively avoid known setup issues by using an update setup.
For answers to frequently asked questions about slipstreaming, see the SQL Server 2008 Slipstream Frequently Asked Questionstopic on the following Microsoft Web site:
More information
When you run the original release version of SQL Server 2008 Setup, the Setup program copies itself on the local computer, and then re-runs from the local copy. Therefore, if there is a later version of the support files on the computer, the Setup program will run these updated files. Therefore, you can update the SQL Server 2008 Setup support files before you run the Setup.exe file.
Starting from SQL Server 2008 Service Pack 1, you can update SQL Server 2008 by using the slipstream infrastructure. When you install Service Pack 1 by using the slipstream procedure or install to an existing SQL Server 2008 installation, an entry is created for the Service Pack in Add or Remove Programs. You can uninstall the service pack by using this entry.
To verify whether a service pack is installed correctly, run the SQL Discovery report that is available in the SQL Server 2008 Installation Center. You should see the features are version 10.n.xxxx, where n represents the service pack version. For example, 10.1.xxxx represents Service Pack 1.
The following steps describe how to update SQL Server 2008 Setup when a Setup issue occurs:
To use these methods, the administrator must obtain the updated SQL Server 2008 Setup support files by downloading the latest CU or hotfix, or service pack. For information about the Setup fixes that are included in the latest hotfix and for information about how to download the hotfix, see the "SQL Server 2008 Setup hotfixes" section. After you obtain the updated SQL Server 2008 Setup support files, use one of the following methods.
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.
Starting from SQL Server 2008 Service Pack 1, you can update SQL Server 2008 by using the slipstream infrastructure. When you install Service Pack 1 by using the slipstream procedure or install to an existing SQL Server 2008 installation, an entry is created for the Service Pack in Add or Remove Programs. You can uninstall the service pack by using this entry.
To verify whether a service pack is installed correctly, run the SQL Discovery report that is available in the SQL Server 2008 Installation Center. You should see the features are version 10.n.xxxx, where n represents the service pack version. For example, 10.1.xxxx represents Service Pack 1.
How to update an installation of SQL Server 2008
When you try to install SQL Server 2008 from a DVD or from a network share, the installation fails because of an issue with the release version of the Setup program.The following steps describe how to update SQL Server 2008 Setup when a Setup issue occurs:
- 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.
- If the SQL Server 2008 Setup support files are not installed, see the "Proactively running setup" section.
- If a fix is available through a hotfix, download the CU or the hotfix, and then install it on the computer by running the .exe file or by using the command line. The package detects the SQL Server 2008 Setup support files on the computer and then applies a new version of the SQLSupport.msi file.
- Run the Setup program again from the DVD or from the network share. The Setup program detects that a later version of the SQLSupport.msi file is available on the computer, and the Setup program runs from the local version on the computer instead of from the DVD or network share.
Limitations
The following limitations apply when you update the Setup program or use the slipstream procedure:- Important You must uninstall a failed installation if the Summary.txt log file indicates that you must uninstall.
- If you use the slipstream procedure to upgrade an installation to a Wow64 installation, you must perform one of the following additional steps:
- Specify the /Action parameter on the command line in addition to the /x86 parameter.
- On the Options page of the Installation Center, select x86.
- 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.
- When you copy slipstream packages, use paths that do not contain spaces. If you specify a location that contains spaces for either /PCUSOURCE or /CUSOURCE parameters, a failure occurs with slipstream setup.
Proactively running setup
There are two methods that you can use to update an installation of SQL Server 2008. We recommend that you use the first method because of the following benefits of the slipstream infrastructure:- You can quickly update to SQL Server 2008 SP1 in a single installation.
- Reduce the restart times.
- Improve the overall setup experience.
- Avoid known setup issues.
To use these methods, the administrator must obtain the updated SQL Server 2008 Setup support files by downloading the latest CU or hotfix, or service pack. For information about the Setup fixes that are included in the latest hotfix and for information about how to download the hotfix, see the "SQL Server 2008 Setup hotfixes" section. After you obtain the updated SQL Server 2008 Setup support files, use one of the following methods.
Use the slipstream procedure to update SQL Server 2008
This method allows you to update the entire product when you run the SQL Server 2008 Setup program after following one of the following procedures:Procedure 1: Basic slipstream steps
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
You can obtain the .NET Framework 2.0 SP2 from the following Web site in Microsoft Download Center:
http://www.microsoft.com/downloads/details.aspx?FamilyID=5b2c0358-915b-4eb5-9b1d-10e506da9d0f&displaylang=en - .NET Framework 3.5 SP1 for other editions
To download and install the .NET Framework 3.5 SP1, visit the following Microsoft Web site: - Windows Installer 4.5
To download and install Windows Installer 4.5, visit the following Microsoft Web site:
- .NET Framework 2.0 SP2 for SQL Server 2008 Express Edition
- 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:
SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1 - 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:
C:\SP1\x64\setup\1033\sqlsupport.msi - Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:
Setup.exe /PCUSource=C:\SP1
For More Information please visit https://support.microsoft.com/en-us/kb/955392
No comments:
Post a Comment