Loading

How to setup a Failover sql server in SharePoint 2013

Nagabhushana Bs

7y960

Hi All,

We have a primary SQL server and another sql server for Failover. In central administration, when i click on the WSS_Content database that will take me to the next screen- where i can see its details and including Failover database server text box field.

Here we can enter the Failover server machine name. Is it enough or do we need to configure the server by executing any Powershell commands or anything else.Kinldy reply.

-Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Waqas Sarwar7y ago
If mirorring the properly configured on SQL Server side then adding the failover server via central admin will work.

but i will highly advise to you test the configuration before going live. here is the detailed link which will guide you:

https://blogs.technet.microsoft.com/praveenh/2010/12/28/sharepoint-2010-is-now-mirroring-aware/
0