Avatar of barnesco
barnesco
 asked on

SQL cluster group error

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
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment
barnesco

8/22/2022 - Mon
x-men

can you move the cluster group to node B?
barnesco

ASKER
I can, but it doesn't automatically failover. I have start SQL server manually.
x-men

so SQL does not depend on drive D?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
DBAduck - Ben Miller

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
barnesco

ASKER
X-men, SQL does not depend on drive D.

Dbaduck, that makes sense and thanks for clarifying.