How to slipstream SQL Server 2008 R2 and a SQL Server 2008 R2 Service Pack 1 (SP1)

转载 2016年03月10日 10:46:00


With the release SQL Server 2008 R2 SP1, I have compiled the list of steps to create a slipstream drop. Once you have created this slipstream drop, you can install the original release of SQL Server 2008 R1 and SP1 at the same time. The slipstream functionality performs a single installs that is quicker when compared to installing the original release and then applying the service pack. Additionally this slipstream drop fixes any Setup issues that prevent a successful installation or upgrade that has been addressed in SP1. See this KB2528583 for a list on fixes in Service Pack 1. This slipstream drop is for new installation or upgrades,. To patch existing SQL Server 2008 features, download SP1 from the download center or obtain from Microsoft Update when available.

Here are the steps:

  1. Copy your original SQL Server 2008 R2 source media to C:\SQLServer2008R2_SP1

  2. Download the SQL Server 2008 R2 SP1 packages from here. You need to download all Service Pack 1 architecture packages:

    • SQLServer2008R2SP1-KB2528583-IA64-ENU.exe
    • SQLServer2008R2SP1-KB2528583-x64-ENU.exe
    • SQLServer2008R2SP1-KB2528583-x86-ENU.exe
  3. Extract each of the SQL Server 2008 SP1 packages to C:\SQLServer2008R2_SP1\SP as follows:

    SQLServer2008R2SP1-KB2528583-IA64-ENU.exe /x:C:\SQLServer2008R2_SP1\SP
    SQLServer2008R2SP1-KB2528583-x64-ENU.exe /x:C:\SQLServer2008R2_SP1\SP
    SQLServer2008R2SP1-KB2528583-x86-ENU.exe /x:C:\SQLServer2008R2_SP1\SP

    Ensure you complete this step for all architectures to ensure the original media is updated correctly.

  4. Copy Setup.exe from the SP extracted location to the original source media location. Here is the robocopy command:

    robocopy C:\SQLServer2008R2_SP1\SP C:\SQLServer2008R2_SP1 Setup.exe

  5. Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in C:\SQLServer2008R2_SP1\SP\ to C:\SQLServer2008R2_SP1\ to update the original files. Here is the robocopy command:

    robocopy C:\SQLServer2008R2_SP1\SP\x86 C:\SQLServer2008R2_SP1\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
    robocopy C:\SQLServer2008R2_SP1\SP\x64 C:\SQLServer2008R2_SP1\x64 /XF Microsoft.SQL.Chainer.PackageData.dll
    robocopy C:\SQLServer2008R2_SP1\SP\ia64 C:\SQLServer2008R2_SP1\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

  6. Determine if you have a DefaultSetup.INI at the following locations:


    If you have a DefaultSetup.INI at the above locations, add the following lines to each DefaultSetup.INI:


    If you do NOT have a DefaultSetup.INI, create one with the following content:

    ;SQLSERVER2008 R2 Configuration File

    and copy to the following locations


This file will tell the setup program where to locate the SP source media that you previously extracted.

  1. Run setup.exe as you normally would.

How can I tell I am slipstreaming:

1) You should see the “Update Setup Media Language Rule” on the Installation Rules dialog:


2) On the Ready to Install dialog, the Action will indicated (“Slipstream”):


3) You will see the PCUSource parameters specified in the Summary log:


4) Results from SQL Discovery Report launched from Installation Center (first CU for SP1)


sqlserver 2008 r2 直接下载地址(百度云)

之前下载的sqlserver2008发现不能附加,就卸载了,重新找到了sqlserver2008R2的百度云资源 卸载sqlserver2008还是有点麻烦,不过就是需要删除注册表中的信息 自己来...
  • zhangvalue
  • zhangvalue
  • 2017年07月12日 17:36
  • 55066

Microsoft® SQL Server® 2008 R2 Service Pack 1正式版

最近有些忙,今天看到微软已经在7月11日发布Microsoft® SQL Server® 2008 R2 Service Pack 1正式版,下载地址为:
  • downmoon
  • downmoon
  • 2011年07月21日 14:24
  • 6939

SQL Server 2008 Service Pack 1 简体中文版发布

SQL Server 2008 Service Pack 1 (SP1) 现在已可供使用.您可以使用这些套件升级下列任何一种 SQL Server 2008 版本.注意:我们致力于维持包含 Servi...
  • bluman_cisco
  • bluman_cisco
  • 2009年04月13日 10:07
  • 490

SQL Server 2005 Service Pack 1

SQL Server 2005 Service Pack 1SQL Server 2005 Service Pack 1Brief DescriptionDownload Service Pack 1...
  • tuwen
  • tuwen
  • 2007年11月20日 14:56
  • 1767

Microsoft SQL Server 2008 R2 Express Service Pack1官方下载地址

Microsoft SQL Server 2008 R2 Express Service Pack1官方下载地址:
  • jsyhello
  • jsyhello
  • 2012年07月14日 07:13
  • 1506

Microsoft® SQL Server® 2008 Express以及Microsoft® SQL Server® 2008 R2 SP1下载地址

Microsoft® SQL Server® 2008 Express
  • zfanlong1314
  • zfanlong1314
  • 2011年11月01日 11:49
  • 1112

如何获取SQL Server的service pack的版本?

方法一select serverproperty(ProductVersion)select serverproperty(ProductLevel) 方法二select @@versionSQL S...
  • NinGoo
  • NinGoo
  • 2005年01月07日 10:05
  • 1271

visual studio 2008 安装service pack 1的神BUG

网上也有很多安装 vs2008安装SP1失败的评论。大部分的说法都是认为安装包中的文件有问题。说是在安装前修改ISO的中的配置文件。 当然也有人说是需要关闭防火墙,并且保持WINDOWS UPDAT...
  • mystudy2000
  • mystudy2000
  • 2016年04月03日 19:50
  • 753

Windows Server 2008 R2 运行.Net 3.5 SP1

【赛迪网报道】微软公司推出的 .net是XML网页服务(Microsoft XML Web services)平台。XML Web services 允许应用程序通过 Internet 进行通讯和共享...
  • lpy3654321
  • lpy3654321
  • 2012年10月24日 15:20
  • 1740

SQL Server 2008 、 SQL Server R2 版本号

版本号取自 SERVERPROPERTY('PRODUCTVERSION')   10.0.1600.22 SQL Server 2008 RTM 10.0.1763.0 SQL Server...
  • snowfoxmonitor
  • snowfoxmonitor
  • 2012年05月10日 08:29
  • 14692
您举报文章:How to slipstream SQL Server 2008 R2 and a SQL Server 2008 R2 Service Pack 1 (SP1)