I wrote an earlier article on how to configure SQL Mirroring to provide database resilience, in this article I will go through how to configure SharePoint to use this new found resiliency.Once you have configured your database mirror you need to instruct SharePoint to use it in the event of a Database Server failure, to do this use the following Powershell command:Get-SPDatabase |?{$_.Name.ToString() -match “YourContentDB”} | %{$_.AddFailoverServiceInstance(“YourSQLMirrorServer”);$_.Update()}If you want to see the current Failover Server assigned to a specific database you can run the following command:Get-SPDatabase |?{$_.Name.ToString() -match “YourContentDB”} | select name, failoverserver