How to find out which physical node the virtual server is using

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

>--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

How to find IP address or Cluster Name of SQL server 2000

Dear All,
Here is the scenario:
We have production and We have a DR Site.
The database is getting replicated from production sit to DR site using
log shipping.
Now the issue is:
We have unique transaction id for each transaction. For the
transactions being made at DR site, we want to have separate series.
Application uses stored proc to generate new transaction id id at
production. We want same stored procedure to handle this situation by
identifying SQL server instance name OR Cluster Name OR IP address and
generate the transaction id based on the findings.
Can anybody help me, how to find either of the three.
Thanks in advance.
AmarHi,

> identifying SQL server instance name OR Cluster Name OR IP address and
Have a look at SERVERPROPERTY() function in Books OnLine.
Robert
<emailtoamar@.gmail.com> wrote in message
news:1143535977.511229.222400@.i40g2000cwc.googlegroups.com...
> Dear All,
> Here is the scenario:
> We have production and We have a DR Site.
> The database is getting replicated from production sit to DR site using
> log shipping.
> Now the issue is:
> We have unique transaction id for each transaction. For the
> transactions being made at DR site, we want to have separate series.
> Application uses stored proc to generate new transaction id id at
> production. We want same stored procedure to handle this situation by
> identifying SQL server instance name OR Cluster Name OR IP address and
> generate the transaction id based on the findings.
> Can anybody help me, how to find either of the three.
> Thanks in advance.
> Amar
>