Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Recovering and troubleshooting Failover Cluster Failure


The installation of failover clustering is not an error-resistant process. Maintaining the cluster instances is another important task to keep up. The failure may occur during the failover process, when adding a node to an existing cluster farm, or due to a hardware failure. Viewing the cluster-wide events requires supportive tools and methods to recover a failover clustering instance failure and troubleshoot any problems that are repetitive in the clustering nodes. A cluster on an expensive hardware system is of no value, if the support infrastructure is not fault tolerant, such as power redundancy or network redundancy.

Once the failover cluster nodes are installed, the first step is to test the failover and failback methods to ensure that the nodes are configured properly to provide the high-availability solution. In this recipe, we will go through the process of recovering and troubleshooting a failover clustering failure with a...