Solved

SQL cluster group error

Posted on 2014-01-09
5
685 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
ID: 39770750
can you move the cluster group to node B?
0
 

Author Comment

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

Expert Comment

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

Accepted Solution

by:
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.
0
 

Author Comment

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

Dbaduck, that makes sense and thanks for clarifying.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

948 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

23 Experts available now in Live!

Get 1:1 Help Now