Monday, 27 May 2013

Update SQL 2008 r2 Service Pack 2 into SQL 2008 r2 Installation Pack - Slipstream procedure

Install SQL 2008 R2 in Windows server 2012 Cluster required SP


1. Download SQL 2008 r2 sp2. Save in C: drive
     http://www.microsoft.com/en-my/download/details.aspx?id=30437

2. Extract SQL sp2 to C: drive.
    Command prompt: SQLServer2008R2SP2-KB2630458-x64-ENU /x:C:\SP2
 
3. Run the Service pack setup files.
    Command prompt: SP2\1033_enu_lp\x64\setup\sqlsupport_msi\sqlsupport.msi
 


 
 
4. Run the SQL setup files from SQL media kit.
     a) Change directory. Command prompt: z:    (my media kit in Z:)
     b) Run setup.  Command prompt: setup.exe /PCUSource=C:\SP2
    
    Note: If install SQL 2008 r2 in Windows Server 2012, Program Compatibility Assistant will prompt. Select Run the program without getting help.
 
5. Install SQL as normal.
 
 
6. Verify have completed a slipstream update.
 
    a) On Installation Rules, Update Setu Media Language Compatibility show in list as below.
 
    b)On ready to install, right panel under action, install slipstram show as below.
 

#Windows Server 2012 - Install .Net Framework 3.5 features

First remove windows update KB below if installed.
  • KB2966826
  • KB2966827
  • KB2966828


Method 1

1. Add feature, select .Net Framework 3.5 features

2. Select Specify an alternate sources path (highlighted) 

3. Enter D:\Sources\SxS\     (D: = Windows server installation kit or mount the ISO, my drive here is D:)

4. .NET Framework installed.

Note: If unable to install, try copy ISO to local disk and mount agains, or change another installation kit.

Saturday, 11 May 2013

#Hyper-V - Live Migrating "Migration Attempt Failed" - Error 1205

Hyper-V Live Migrating "Migration Attempt Failed" - Error 1205

Error 1205 The Cluster service failed to bring clustered service or application "ServerName" completely online or offline. One or more resources may be in failed state. This may impact availability of clustered service or application.

Method

Disable antivirus or

Antivirus scan exclude "ClusterStorage" folder

exclude *.XML
              *.VHD
              *.VHDX
              *.AVHD
              *.AVHDX
              *.VFD
              *.VSV
              *.ISO

exclude VMMS.exe
              VMWP.exe

Optional:
exclude C:\ProgramData\Microsoft\Windows\Hyper-V
              C:\Users\Public\Documents\Hyper-V\Virtual Hard Disks