製作整合SP1的SQL Server 2008 R2 安裝媒體

[schumi]

http://forum.icst.org.tw/phpbb/viewtopi ... 21&t=18145

SQL Server 2008 with SP1 整合光碟；匯集(Slipstreaming)安裝
http://sharedderrick.blogspot.com/2010/ ... aming.html

Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1
http://blogs.msdn.com/petersad/archive/ ... -drop.aspx

Create a merged (slipstream) drop containing SQL Server 2008, Server Pack 1 and a Cumulative Update (CU) based on Server Pack 1
http://blogs.msdn.com/petersad/archive/ ... ack-1.aspx

====================================================================

關於 robocopy
1. Windows XP/2003 沒有，可以去下載 Windows Server 2003 Resource Kit Tools 安裝，裡面有
http://www.microsoft.com/downloads/deta ... laylang=en
2. Windows Vista/7/2008/2008R2 已經內建

====================================================================

1. 拷貝光碟內容到 c:\SQLServer2008_FullSP1

2. 下載 SQL 2008 SP1
http://www.microsoft.com/downloads/deta ... c6a4f9dc19
architectures of Service Pack 1 should be included, the package names are as follows:

要整合繁體中文版請下載
SQLServer2008SP1-KB968369-IA64-CHT.exe
SQLServer2008SP1-KB968369-x64-CHT.exe
SQLServer2008SP1-KB968369-x86-CHT.exe

3. 解壓縮

SQLServer2008SP1-KB968369-IA64-CHT.exe /x:c:\SQLServer2008_FullSP1\PCU
SQLServer2008SP1-KB968369-x64-CHT.exe /x:c:\SQLServer2008_FullSP1\PCU
SQLServer2008SP1-KB968369-x86-CHT.exe /x:c:\SQLServer2008_FullSP1\PCU

4. 從 PCU 目錄拷貝 Setup.exe 和 Setup.rll 到原來目錄

robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe
robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll

5. 拷貝所有檔案 (除了 Microsoft.SQL.Chainer.PackageData.dll)

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

6. 在下面目錄各有一個 defaultsetup.ini

* C:\SQLServer2008_FullSP1\x86
* C:\SQLServer2008_FullSP1\x64
* C:\SQLServer2008_FullSP1\ia64

各增加一行
PCUSOURCE=".\PCU".

7. 用 UltraISO 做成光碟影像檔案 (.iso)(有 6GB 多)
或直接執行 setup.exe 安裝，安裝完成就是 SQL 2008 with SP1