Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Clu
ster (2 boxes)
The I attach th the SQL Server Thru Enterprise Manager, right -click databas
es, and select new database...I can type the name of the new database, but w
hen I go to look for the other drives in the cluster I can only see the (Mas
ter) drive ...where SQL Ser
ver is installed. How can I view all of the current resources (drives) owne
d by that node in the cluster?
Thanks,
WarrenYou have to add them to the cluster ... This is in cluster administrator.
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:41DA8BCE-72D7-41AF-9A9A-5DD06DBCF760@.microsoft.com...

quote:

---

> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition

---

Cluster (2 boxes)

quote:

---

> The I attach th the SQL Server Thru Enterprise Manager, right -click

---

databases, and select new database...I can type the name of the new
database, but when I go to look for the other drives in the cluster I can
only see the (Master) drive ...where SQL Server is installed. How can I
view all of the current resources (drives) owned by that node in the
cluster?

quote:

---

> Thanks,
> Warren

---

|||Thanks Wayne.
I can see all the drive within the cluster administrator. Is there another
step that i didn't do? The fail-over works perfectly and each node owns it'
s own resources. But I can view the different drives within Enterprise Manag
er...
Thanks,
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager