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.