SQL DBA learning curve

Hi all,

I was looking for ways to do a slipstream installation for SQL server 2008 R2 SP2 .. I referred to this for some important info .. and below are steps I

followed to achieve the same .. A great THANKS to Peter Saddow (Microsoft)  for his blog …

Slipstream allows you to do service pack installation along with the initial installation of SQL server ..

this helps save downtime and avoid any manual installation errors …

Steps as below ..

1> copy your original SQL server setup to a folder named SQL2008R2

2> download the service pack from this location . make sure you download them all 3 (x86,x64 and ia64)

irrespective of the fact you will eventually be using one … but to make sure your SP are complete in every sense ..

3> you need to create a FOLDER named SP2 (or whatever you want to name it ) with in the folder named SQL2008R2

(that is the location where your original installation is placed)

4> extract the 3 downloaded EXE into this newly created FOLDER named SP2 (below are the command)

SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:T:\SQL2008R2\SP2

SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:T:\SQL2008R2\SP2

SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:T:\SQL2008R2\SP2

remember .. T:\SQL2008R2 contains the original SQL server setup and we created a folder named SP2 within T:\SQL2008R2

5> Robocopy the SETUP.exe file from newly created folder SP2 into original setup .. that we want to replace the setup.exe file of original SQL server setup with SP2 setup.exe

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2 T:\SQL2008R2 setup.exe

6> Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in T:\SQL2008R2\SP2\<architecture> to T:\SQL2008R2\<architecture> to update the original files. Here is the Robocop command

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\x64 T:\SQL2008R2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\x86 T:\SQL2008R2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll

T:\SQL2008R2_SP2>robocopy T:\SQL2008R2\SP2\ia64 T:\SQL2008R2\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

7> check whether you have DefaultSetup.INI .. at this location .. mostly you should I them .. if not we will create it

T:\SQL2008R2\x64

T:\SQL2008R2\x86 and

T:\SQL2008R2\ia64

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

PCUSOURCE=”.\SP2″

note : SP2 is the folder we created within the original setup files .. if you used a different name .. please use that folder name ..

this tells the installation setup  that service patch files are located within this folder ..

8> If you do not find any DefaultSetup.INI files in a rare case , create one with the following content:

;SQLSERVER2008 R2 Configuration File

[SQLSERVER2008]

PCUSOURCE=”.\SP2″

and copy to the following locations

T:\SQL2008R2\x64

T:\SQL2008R2\x86 and

T:\SQL2008R2\ia64

9> run the setup as you would do normally  from with in T:\SQL2008R2 ..

below are the indications that you are doing a slipstream installation …

10> for this … I have only chosen database engine .. in the features ..

11> confirm tht you see “Update Setup Media Language Rule” as PASSED in the installation rules page

12> On the Ready to Install dialog, the Action will indicated (“Slipstream”) … this confirms … that we are going right .. till now ..

13>  PCUSource parameters in the summary log .. states that it picked up the SP2 from the path we pointed it to ..

this confirms that our installation has gone right … do confirm the same by connecting using SSMS

*************************************************

Slipstream has reportedly given issues if we try to do installation of reporting services .. I have not selected the same for now ..

refer this for details http://sirsql.net/blog/2012/11/15/issues-with-slipstreaming-service-pack-2-on-to-sql-2008-r2.html

https://connect.microsoft.com/SQLServer/feedback/details/771260/sql-2008-r2-with-slipstreamed-sp2-fails-when-install-includes-reporting-services

I will try to do a reporting service installation in my next post ….  ENJOY 🙂