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.

August 2015 CU for SharePoint 2010 is available for download

 August 2015 CU for SharePoint 2010 is available for download

The product group released the August 2015 Cumulative Update for the SharePoint 2010 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 SharePoint security fixes released with August 2015 PU.

Be aware that CU is a Post-SP2 hotfix. It is required to have SP2 installed before installing the CU.

It is required to have SP2 installed for the base product and all installed language packs to install August 2015 CU for SharePoint 2010.

This CU includes all SharePoint 2010 fixes (including all SharePoint 2010 security fixes) released since SP2. The CU does not include SP2.

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

• KB 3055049 - SharePoint Foundation 2010
• KB 3055040 - SharePoint Server 2010
• KB 3055038 - Project Server 2010

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

• Download SharePoint Foundation 2010 August 2015 CU
• Download SharePoint Server 2010 August 2015 CU
• Download Project Server 2010 August 2015 CU

After installing the fixes you need to run the SharePoint 2010 Products Configuration Wizard on each machine in the farm.

Be aware that the SharePoint Server 2010 CU contains the SharePoint Foundation CU.
That means only one package has to be installed for the SharePoint 2010 product family.

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.

SharePoint 2010 Management Shell does not load with Windows Power Shell 3.0

SharePoint 2010 Management Shell does not load with Windows Power Shell 3.0

Issue: After you install Microsoft SharePoint Server 2010 and Windows Power Shell 3.0 on a server, you receive one or both of the following error messages when you start SharePoint 2010 Management Shell:

Error message 1:The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

Error message 2:Microsoft SharePoint is not supported with version 4.0.30319.17929 of the Microsoft .Net Runtime.

Workaround: please follow the work around mentioned below.

To work around this issue, change the Target field value for SharePoint 2010 Management Shell. To do this, follow these steps:

1.   Click Start, and then right-click SharePoint 2010 Management Shell.

2.   Click Properties.

3.   Click the Shortcut tab in the SharePoint 2010 Management Shell Properties window.

4.   Input the following value in the Target field:

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Version 2.0 -NoExit " & ' C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\CONFIG\POWERSHELL\Registration\\sharepoint.ps1 ' "

 


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.