How to clean up the cluster resource group and the databases on a shared disk after a failed failover Cluster Complete operation in SQL Server 2008

Article translations Article translations
Article ID: 953505 - View products that this article applies to.
Expand all | Collapse all

INTRODUCTION

This article describes how to clean up the cluster resource group and the databases on a shared disk after a failed failover Cluster Complete operation in Microsoft SQL Server 2008. After the clean up is completed and the issue that caused the failure is corrected, you can rerun the Complete Failover Cluster setup operation.

MORE INFORMATION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To clean up the cluster resource group and the databases, follow these steps:
  1. Delete the following resources that were created for the SQL Server Failover Cluster instance if they are included in the resource group:
    • SQL IP Address(es)
    • SQL Network Name
    • SQL Server
    • SQL Server Agent
    • Analysis Services
  2. Delete the following database files for the SQL Server Failover Cluster instance:
    • Master.mdf and Mastlog.ldf
    • Model.mdf and Modellog.ldf
    • Msdbdata.mdf and Msdblog.ldf
    • Tempdb.mdf and Templog.ldf
  3. If they are present, delete the following registry keys on all nodes of the cluster that were prepared for the SQL Server Failover Cluster instance:
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS10.<InstanceID>\Cluster
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10.<InstanceID>\Cluster
    Notes
    • In this step, InstanceID is a placeholder for the instance ID for the SQL Server Failover Cluster instance.
    • Make sure that the Cluster key is deleted on all nodes, not only the node where the Complete Failover Cluster operation was run.
  4. If they are present, change all values under the following registry keys to 2 ("prepared") on all nodes of the cluster that were prepared for the SQL Server Failover Cluster instance:
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS10.<InstanceID>\ClusterState
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10.<InstanceID>\ClusterState
    Notes
    • In this step, InstanceID is a placeholder for the instance ID for the Failover Cluster instance.
    • Make sure that the ClusterState key values are changed on all nodes, not only the node where the Complete Failover Cluster operation was run.
  5. If they are present, change all values under the following registry keys to 1 ("installed") on all nodes of the cluster that were prepared for the SQL Server Failover Cluster instance:
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS10.<InstanceID>\ConfigurationState
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10.<InstanceID>\ConfigurationState
    Notes
    • In this step, InstanceID is a placeholder for the instance ID for the Failover Cluster instance.
    • Make sure that the ConfigurationState key values are changed on all nodes, not only the node where the Complete Failover Cluster operation was run.

REFERENCES

For information about how to create a SQL Server 2008 failover cluster, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms179530(SQL.100).aspx

Properties

Article ID: 953505 - Last Review: March 19, 2009 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
Keywords: 
sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbsetup kbexpertiseinter kbhowto KB953505

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com