Sunday, February 12, 2012

Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Cluster (2 boxes
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?
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...
> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition
Cluster (2 boxes)
> 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?
> 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 Manager..
Thanks
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager

No comments:

Post a Comment