Improving Availability and enhancing Programmability - Microsoft SQL Server 2008 R2 Administration - page 223

11. Resolve the disk controller problems on the DBIACL02 node by installing the
required firmware drivers.
12. Ensure that MSCS cluster service is working on DBIACL02 node.
13. On the DBIACL01 node, attempt to failover to the recovered node DBIACL02 .
14. If the failover process succeeds, then no further action is required.
15. However, if the SQL Server services fail to come online on the DBIACL02 node,
open the FCM snap-in on the DBIACL01 node to review the cluster log to obtain the
relevant information of the failure.
This completes the steps to recover and troubleshoot the failover cluster failure. For further
information on failover cluster troubleshooting scenario examples, refer to: http://msdn.
microsoft.com/en-us/library/ms189117.aspx.
How it works...
The utility named Failover Cluster Management (FCM) snap-in uses the MSCS on the Windows
operating system. The important FCM tool features are: validate configuration, create cluster
or add node, and migrate settings from a cluster running Windows Server 2003. The tool
highlights the required features, which are useful to monitor and administer the failover
cluster management. Using the FCM utility, both Windows and SQL Server events such as
health and performance can be monitored. In addition to FCM, we can make the best of use
of SQL Server tools and services with failover clustering, refer to http://msdn.microsoft.
com/en-us/library/ms175549.aspx for more information.
See also
Refer to the recipe Installing and configuring failover clustering services for the relevant steps.
Implementing Database Mirroring features
and performance enhancements
Database mirroring involves re-applying every modification operation that occurs in the
primary database onto the mirror database. The physical log record is applied to the mirror
database and keeps an exact copy of the primary database.
SQL Server 2008 provides many enhancements that are related to the performance of
database mirroring. In this recipe, we will go through the important steps required to
implement database mirroring features and performance enhancements using SQL Server
2008 R2.