You are currently offline, waiting for your internet to reconnect

When you install failover clustering in SQL Server 2008, the node on which failover clustering is installed must own the resource group

INTRODUCTION
Failover clustering in Microsoft SQL Server provides high availability for an instance of SQL Server. A failover cluster is a combination of one or more nodes and two or more shared disks. A node is a server in the cluster. The shared disks are known as a resource group. This resource group is owned by a single node in the cluster.

This article discusses resource group and shared disk ownership when you install failover clustering in Microsoft SQL Server 2008.
MORE INFORMATION
When you install failover clustering in SQL Server 2008, the node where failover clustering is installed must own the resource group and the shared disks in that group. The failover clustering installation will fail if any one of the following conditions is true:
  • The disk resource is not owned by the local node.
  • The disk resource is a cluster quorum disk.
  • The disk resource has non-disk dependencies.
  • The disk resource has dependencies outside of the same resource group.
  • The disk resource has dependents outside of the same resource group.
Note This behavior applies to both Integrated failover cluster installations and Advanced/Enterprise failover cluster installations.

When a shared disk is not available, an entry that resembles the following may be logged in the SystemConfigurationCheck_Report.htm file.
Computer NameRule NameRule DescriptionResultMessage/Corrective Action
computernameCluster_SharedDiskFacetChecks whether the cluster on a computer has at least one shared disk available.FailedThe cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.
Note The SystemConfigurationCheck_Report.htm file is located in the "Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\date_time" folder.
REFERENCES
For more information about failover clustering, see the "Getting Started with SQL Server 2008 Failover Clustering" and "Installing a SQL Server 2008 Failover Cluster" topics in SQL Server 2008 Books Online.
"SQL Server 2008 Installation" "SQL Server 2008 Configuration" SQL2008RelNote SetupConfiguration SQL2008RelNoteInstallation FailoverCluster
Properties

Article ID: 955780 - Last Review: 03/19/2009 22:29:16 - Revision: 2.0

Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2008 Developer

  • sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbclustering kbtshoot kbinfo KB955780
Feedback
amp;did=1&t=">