SQL high available failover

SQL high available failover:

Description: Most of the administrators think that the failover should do in SQL HA by the Windows Cluster, but it’s not true. we need to do the failover by the HA method which is configured in SQL.

In this article I am providing the steps to do the failover.

Steps: Please follow the steps below to do failover in HA.

As per below screen ,Secondary Don’t have any resources so patch first in secondary.

                                 

 Once patching done successful in secondary do failover resources to secondary, then  primary becomes secondary.

Do patch in other secondary now.

Failover steps:

1.      Logon to the SQL server with SQL account

2.      Go to SQL management studio.

3.      Expand availability groups as per the screen below.

4.      Right click the DB

5.      Click on Failover

6.      Click on next in introduction

7.      Select a new primary replica->next

8.      connect to replica->click next.

9.      successful

                                 

 

 
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

August 2015 CU for SharePoint 2013 is available for download

August 2015 CU for SharePoint 2013 is available for download

 The product group released the August 2015 Cumulative Update for the SharePoint 2013 product family.

For August 2015 CU we have full server packages (also known as Uber packages). No other CU is required to fully patch SharePoint.

As this is a common question: Yes, August 2015 CU includes all fixes from August 2015 PU.

ATTENTION:

Be aware that all Updates for SharePoint 2013 require SharePoint Server 2013 SP1 to be installed first.

Please also have a look at the article that discusses how to properly patch a SharePoint 2013 farm which has Search enabled (see below).

This CU includes all SharePoint 2013 fixes (including all SharePoint 2013 security fixes) released since SP1. The CU does not include SP1. You need to install SP1 before installing this CU.

The KB articles for August CU should be available at the following locations in a couple of hours:

• KB 3055004 - SharePoint Foundation 2013 August 2015 CU
• KB 3055009 - SharePoint Server 2013 August 2015 CU
• KB 3055005 - SharePoint Server 2013 with Project Server August 2015 CU
• KB 3055003 - Office Web Apps Server 2013 August 2015 CU - This is also a security fix!

The Full Server Packages for August 2015 CU are available through the following links:

• Download SharePoint Foundation 2013 August 2015 CU
• Download SharePoint Server 2013 August 2015 CU
• Download Project Server 2013 August 2015 CU
• Download Office Web Apps Server 2013 August 2015 CU

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.