SharePoint Failover Database Server

From ecrets of SharePoint – Tip of the Day

Mattias Karlsson

A new feature in SharePoint 2010 is that SharePoint is now “mirroring-aware.” As you may have seen when creating a new content database in SharePoint 2010, you have the option to specify the failover server. This property can be used when you have set up a mirroring of the SQL-layer, allowing SharePoint to add the failover server to the connection string. In case of a SQL-Server time-out, this allows the SQL server to failover to the configured mirroring server and SharePoint will try to connect to the specified server.

Posted in SharePoint Tagged permalink

About Rick Backus

A technology consultant with over 25 years of IT, consulting and business technology industry experience. Specializing in integrating application, information and content management with business process and network infrastructure. Helping clients get the most out of technology to enable increased productivity, profitability, customer satisfaction and competitive advantage.

Leave a Reply