SQL cluster group error

Posted on 2014-01-09
Last Modified: 2014-01-10
On a SQL 2005 cluster, drive D was deleted then restored on Node A but not on Node B--aka, the server cannot see drive D on Node B. Node A works great and SQL is running, but Node B is still looking for drive D in the cluster group and shows a fat read X for the group. There are no binaries or SQL files on drive D.

Will deleting the SQL group with drive D on Node 2 cause a problem for the Node 1 and for the SQL cluster in general?

Question by:barnesco
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 18

Expert Comment

ID: 39770750
can you move the cluster group to node B?

Author Comment

ID: 39770910
I can, but it doesn't automatically failover. I have start SQL server manually.
LVL 18

Expert Comment

ID: 39771013
so SQL does not depend on drive D?
LVL 24

Accepted Solution

DBAduck - Ben Miller earned 500 total points
ID: 39772302
When dealing with a Cluster Group it is there in the Cluster regardless of Nodes. Nodes participate in the cluster, so you cannot delete the Cluster Group on Node B because the Cluster Group is not ON Node B it is in a Cluster and Node B is a Node in the cluster.

When dealing with Drives in Clusters, you have to make the drive available to the Cluster which means that whichever Node the Group that contains that Drive can move to must have ability to bring that drive online.  If it cannot, you should remove the drive from the cluster group not remove the cluster group from a node.

Author Comment

ID: 39772462
X-men, SQL does not depend on drive D.

Dbaduck, that makes sense and thanks for clarifying.

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question