sql server clustering: missing drives -- sql server clustering

missing drives

Mirna
1/27/2004 11:06:13 AM

sql server clustering:

The servers are W2003 Enterprise
SQL is 2000 Ent sp3a
Active/Passive

I just finished configuring the cluster and it looks fine
except SQl does not see all drives. In other words when
trying to create the database in enterprise manager
server does sees only one drive. It bahaves the same when
trying to backup the database. What could be wrong ?

Thanks for your time,

Re: missing drives

Geoff N.Hiten
1/27/2004 2:12:03 PM

Create a cluster resource for the drive. Then you must add the drive to the
resource group for your SQL Virtual server. Finally, you must change the
dependancies so that SQL server is dependant on the new drive resources.
SQL can then use the drives as database storage.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

[quoted text, click to view]