Primary and Secondary Node -- sql server clustering

Bala Prasad Peddigari
8/31/2006 2:57:02 AM

I just figured it out, this is possible to identify through

select * from ::fn_VirtualServerNodes()

First row is the active and primary node, while others are passive and
secondary nodes

Thanks
Bala

[quoted text, click to view]

Linchi Shea
8/31/2006 5:35:02 AM

We have also noticed that this appears to be empirically correct. But I don't
know whether this is documented formally anywhere.

Linchi

[quoted text, click to view]

m.bohse NO[at]SPAM quest-consultants.com
9/1/2006 6:25:07 AM

[quoted text, click to view]
Sorry but I can't confirm this. We have sevral instances on a
active/active cluster. But no matter on which node an instance is
active the query always returns the same order. Also using the new
management view sys.dm_os_cluster_nodes in 2005 doesn't change the
results.

Markus

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Primary and Secondary Node