A Practical Guide to SharePoint 2013

A Practical Guide to SharePoint 2013
A Practical Guide to SharePoint 2013 - Book by Saifullah Shafiq

Friday, October 21, 2011

SharePoint 2010 Database High Availability (Via berryst)

Extracted from the original article

As one of the high availability options in database used by SharePoint 2010 application, we can set the SQL Server database with SQL high availability mirroring (synchronous mode) or SQL failover cluster. To get in more detail on SQL high availability mirroring, on the SharePoint application side, it's automatic detection if there's failover happened on the mirrored database. Sharepoint will always connect to the prinicple database, as mirror database won't be accessible.

You can refer to my previous article on how to set failover instance on sharepoint database or refer to the following article Plan for availability (SharePoint Server 2010)

But, what about the sql server mirroring side once the failover happen? will it be able to re-syncronize back or do we need to setup the mirroring from the scratch once the failover happened ?

For complete article click here.