Hi,

I have a question regarding how to find out which physical node the
virtual server is using.

Currently my SQL Server 2000 setup is as follows:

Physical Nodes:
---------------
ClusterA
ClusterB

Virtual Server:
---------------
SQLCLUST

I know if I use Cluster Administrator or cluster.exe command line
tool, I can find out which node the resource is using but is there a
stored procedure from the database i can use to find out which node
it's using?

Thank you in advance.

Wing

Wing,

The clustered SQL depends on the hard drive you have
installed it on. So whichever cluster owns the hard drive
at the momenent- that is the node Cluster is using.

Also, you can check it through the Cluster Administrator
utility.

Log on to OS of Cluster A or B (does not matter) and start
the Cluster Administrator. You will see your Cluster A
and B servers on the left. Click + to expand teh view and
choose Active Groups.

If you see your SQL cluster group under the Active Groups
of Cluster A- then virtual server is using Clsuter A. Same
goes for Cksuter B.

Hope this helps,
Nerses