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
[quoted text, click to view] >-----Original Message-----
>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
>.
You can use xp_cmdshell to run cluster.exe (command line cluster administrator)
To see the parameters for cluster.exe type
cluster/?
Search Microsoft Knowledge Base articles for examples with cluster.exe
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security. Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect http://www.microsoft.com/security/guidance/default.mspx
