Slipstream SQL Server 2008 R2 Service Pack 2

HP-UX、Linux、Tru64 UNIX、NonStop、OpenVMS、Windows Server等,数据中心、虚拟化方案等

版主: xyevolve

版面规则
1. 本版是定位于惠普软件系统及解决方案的技术讨论区。
2. 本版鼓励发帖共同讨论技术问题,不鼓励站内信件私下交流,独知知不如众知知。
3. 本版允许转贴或引用他人的作品,但必须声明原作者信息。
4. 本版禁止发表出售、求购、或其他非技术讨论等帖子。
5. 本版禁止灌水,包括但不限于任何与所讨论主题无关的回复,无意义字符,直接复制其他回复等。
6. 本站附件禁止用于商业目的,请在下载后24小时内删除,本站不对其造成的结果负任何责任。
回复
头像
MUDBOY
创始人
帖子: 3877
注册时间: 2010年 12月 28日 21:17 星期二

Slipstream SQL Server 2008 R2 Service Pack 2

帖子 MUDBOY » 2012年 11月 8日 15:40 星期四

From Slipstream SQL Server 2008 R2 Service Pack 2

One of the new features added to Microsoft SQL Server 2008 and R2 is the ability to slipstream a service pack into the installation. This streamlines the installation, and reduces human error. Now that SQL Server 2008 R2 SP2 is officially out, here's how to build a slipstreamed installation. I've updated the instructions from the MSDN SQL 2008 R2 SP1 blog article to reflect SP2 filenames.

1. Download SQL Server 2008 R2 SP2 here. Note that you need to download all three architectures (IA64, x64, x86) even if you never plan on using them.

SQLServer2008R2SP2-KB2630458-IA64-ENU.exe

SQLServer2008R2SP2-KB2630458-x64-ENU.exe

SQLServer2008R2SP2-KB2630458-x86-ENU.exe


2. Copy your original SQL Server 2008 R2 media to a folder (e.g. SQL2008R2_SP2), I used the E drive so my path was E:\SQL2008R2_SP2.

3. You now need to extract the packages, using the path to where you copied the original source media.

SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:e:\SQL2008R2_SP2\SP
SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:e:\SQL2008R2_SP2\SP
SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:e:\SQL2008R2_SP2\SP

4. Replace the original setup.exe with the SP2 version:

robocopy E:\SQL2008R2_SP2\SP E:\SQL2008R2_SP2 Setup.exe

5. Copy all of the files, excluding folders and the Microsoft.SQL.Chainer.PackageData.dll file to overwrite the non-SP2 files.

robocopy E:\SQL2008R2_SP2\SP\x86 E:\SQL2008R2_SP2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll

robocopy E:\SQL2008R2_SP2\SP\x64 E:\SQL2008R2_SP2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll

robocopy E:\SQL2008R2_SP2\SP\ia64 E:\SQL2008R2_SP2\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

6. To tell the SQL server installer where to find the service pack files you need to update all three DefaultSetup.ini files. They are located under E:\SQL2008R2_SP2\x86, x64 and ia64. Add the following line to the end of each file:

PCUSOURCE=".\SP"

7. Your SP2 slipstream media is now complete. Run Setup.exe like you normally would and enjoy an integrated installation of SQL Server 2008 R2 with SP2.

Update: You may get an installation error if installing on a 64-bit server. You may need to rename the sqlncli.msi file in \SP\1033_ENU_LP\x64\setup\x64 to sqlncli_amd64.msi.

回复