Apply the patch on HA(AlwaysON DB 2012)

Apply the patch on HA(AlwaysON DB 2012)

My test environment consists of two SQL Server 2012 SP1 servers named Primary (principal) and  standby (mirror) that contain one mirrored databases and I'm upgrading to SP2.

Here is a look at the two mirrored instances.

Dashboard report from Primary instance:

Step 1
Always backup all system and user databases before applying patches.

Step 2
Remote Desktop into the "Mirror" server (standby in our example) and download/copy the patch to the server.

Run the query select @@version to get the service pack details as we can see current version is 2012 with sp1 of standby instance.

Step 3

Stop all SQL Services on the "Mirror" server.

Step 4
Run the patch on the "Mirror" server as run as administrator option.

Step 5 : all the component verification passed  click on next

Step 6 : accept the license terms and click on next.

Step 7: Select the feature which you want to get upgrade in my case i want all and click on next

Step 8: selected service will be checked at this stage will fail if any service is in use in my case all service are stop so all passed click on next

Step 9: Here are you ready to update click on upgrade

 Step 10: this process will take time as all component are being upgrade .

Step 11: All the component got upgrade can close the window.

Once the patch is complete, reboot the "Mirror" server.

Step 12: Check the Always on dashboard report and can see DB got again synched if not much change happen on primary during upgrade activity else db will be in recovery mode until recovery not get complete after recovery db mode will be synchronized. 

Step 13:Can see now DB got upgraded to SP2 using

select @@version             

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Now STANBDY got upgraded to sp2.

Step 14: Login to the primary instance  check the dashboard report can see both site are in synched.

Step 15: do the failover for Primary to standby ...right click on Availability group and select the failover option.

Step 16: perform the failover click on next

Step 17: Select the replica to which you want to make as active (new primary) click on next.

step 18: click on connect option

Step 19: will get the login prompt select the correct instance and click on connect option.

Step 20: Will get the window as below and click on next option.

Step 21:Verify the details like which server is current primary and standby click on finish for failover.

Step 22:will take few min to get complete then close the window now standby instance become active instance and primary(old) instance will become passive instance which we can proceed for upgrade.

Step 23: can see in always on Availability group showing as secondary

Step 24: Stop all SQL Services on the primary(old) instance.

Step 25: Run the installer as run as administrator option.

Step 26: accept the license terms and click on next.

 Step 27: Select the feature which you want to get upgrade in my case i want all and click on next

Step 28: selected service will be checked at this stage will fail if any service is in use in my case all service are stop so all passed click on next

Step 29: Here are you ready to update click on upgrade

Step 30:this process will take time as all component are being upgrade .

Step 31: All the component got upgrade can close the window.

Step 32: Once the patch is complete, reboot the server.

Step 33: Check the Always on dashboard report and can see DB got again synched if not much change happen on primary during upgrade activity else db will be in recovery mode until recovery not get complete after recovery db mode will be synchronized.

and we can see DB got upgraded to SP2 and primary AlwaysON HA availability group showing as secondary you do failover again to make ..Primary instance as primary and standby as secondary .  

Do test in you test environment before apply on production , please let us know if facing any issue.