Solved

SQL cluster group error

Posted on 2014-01-09
5
678 Views
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?

Thanks
0
Comment
Question by:barnesco
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:x-men
Comment Utility
can you move the cluster group to node B?
0
 

Author Comment

by:barnesco
Comment Utility
I can, but it doesn't automatically failover. I have start SQL server manually.
0
 
LVL 18

Expert Comment

by:x-men
Comment Utility
so SQL does not depend on drive D?
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
Comment Utility
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.
0
 

Author Comment

by:barnesco
Comment Utility
X-men, SQL does not depend on drive D.

Dbaduck, that makes sense and thanks for clarifying.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now