Wednesday, October 23, 2013

Detailed Installation Step for SQL server 2008 R2 – CU8 upgrade

Detailed Installation Step for SQL server 2008 R2 – CU8 upgrade 
 
Installation Step for SQL server 2008 R2 – CU8 upgrade

NOTE: Downtime required
 If the Servers are in Failover Clusters, please follow the below steps:
[2 active nodes and 1 passive nodes]
[Active Node A, Active Node B, Passive node C]
1.    Upgrade Node C.
2.    failover one instance from Node A to Node C . Now node C is running one instance and Node A has become passive node
3.    Upgrade the node A.
4.    failover one instance from Node B to Node A . Now node A is running one instance and Node B has become passive node
5.    Upgrade the node B.
OR,

[3 active nodes and 1 passive nodes]
[Active Node A, Active Node B, Active Node C, Passive node D]
1.    Upgrade Node D.
2.    failover one instance from Node A to Node D . Now node D is running one instance and Node A has become passive node
3.    Upgrade the node A.
4.    failover one instance from Node B to Node A . Now node A is running one instance and Node B has become passive node
5.    Upgrade the node B.
6.    failover one instance from Node C to Node B . Now node B is running one instance and Node C has become passive node
7.    Upgrade the node C.
 
 
SQL CU08 upgrade steps:
 
 Step 1 :
                    File name :  SQLServer2008R2-KB2871401-x64

                double click on the binary

                              
                Click Continue.
                                                                                     
 Step 2 : Click “Next” to proceed.
                                         
                                                                                                 
 Step 3 : Check the “I accept the license terms” and hit “Next”
                                                       
Step 4: Ensure INSTANCES are selected and hit “Next”                                                                                                                                                
 Step 5: After the checking is completed, hit “Next” to proceed.                                                                                                                                    
  Step 6: Click on “Update” to continue
             
               
                         Installation in progress:                                                                                                                          
                                                                 
                             Upgrade completed:
                                                     

                             Click Close.
   Step 7 : Server will be restarted to take effect. Press “Ok” to reboot the server.
                          Note: if server not rebooted automatically, Do manual reboot.
Step 8 : After the server is rebooted. Perform the following few verifications:

G SQL Management Studio > Help tab > About…
                                      Versions Should be as below : 10.50.4290.0
                                                                                   
  Check in Control Panel > Programs and features > at left pane, click on “ View installed Updates” > Ensure “KB2871401” is in the list.
                                        

                                                                                                                                                 Once the Upgrade is Done Check the SharePoint Central Admin page and rest All web sites are working.               


No comments:

Post a Comment

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X