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:

Go  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.