SQL Instance doesn't see 2nd drive in Cluster Group -- sql server clustering

bluesky4x4 NO[at]SPAM hotmail.com
9/15/2006 6:27:05 AM

We are running Windows 2003 Cluster with SQL Enterprise 2000. We have
10 Cluster Groups setup on the server, each having two drives and a
sql instance. In cluster admin, I can see the two physical drives in
each group, but from SQL enterpise manager, on a given sql instance, I
can only see one drive when setting up a backup process or clicking
restore. If I type in the drive name, it can referernce it, but it does
not show the drive or allow me to browse. Any ideas on how I can get
sql to show both drives?

Rodney R. Fournier [MVP]
9/15/2006 8:51:41 AM

Stop that SQL instance and from within Cluster Administrator add the second
disk as a dependencies to the SQL Server resource.

Bring everything back online and use. You will then have to move your
transactions logs to it.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

[quoted text, click to view]

sql server clustering : SQL Instance doesn't see 2nd drive in Cluster Group