June 12, 2005 at 9:59 pm
I want to do a remote shutdown of a node in a SQL Server cluster. I need to test to see which is the active node, how can I do that?
I've looked at the cluster.exe command line options and I don't see how I can do that with this. With the /Status option it only tells me that each node is online.
Any ideas?
Dennis
June 14, 2005 at 3:27 am
Hi,
by using ipconfig -all you can see if the cluster-ip is active on a node
karl
Best regards
karl
June 14, 2005 at 7:25 am
Also, you can remote desktop (assuming the cluster is Windows 2000/2003 into the SQL Server virtual server (use the network name of the virtualserver). On the login screen, hit the down arrow on the Domain drop-down. It should have the physical server name (this server) listed.
June 14, 2005 at 8:51 am
The IP addresses are alive either if the node is active or not. I also want to do this remotely with a script to test the cluster failover every week.
June 14, 2005 at 8:53 am
I failed to mention, I want to do this automatically every weekend to test the failover of the the SQL cluster.
I know how to do the remote shutodown of the node, I just need to test for which one is active to shut it down to cause the failover.
June 14, 2005 at 9:51 am
usually each node has it's own IP-address, and the virtual server has a different IP, which is only active on the active node.
other methode: if it's an active/passive SQL-Cluster you can use netsvcs to see if the service mssqlserver is running...
Best regards
karl
June 14, 2005 at 11:04 am
Execute sp_who2 and you'll see the active node listed under Hostname somewhere. Under Program Name you would see "Microsoft® Windows® Operating System" if you have Windows 2003.
Linda
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply