Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Cluster

Author  Topic 

swekik
Posting Yak Master

126 Posts

Posted - 2008-10-07 : 14:15:20
How to identify whether the server is Active/active or active /passive??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 14:20:02
You can view this information in Cluster Administrator. If no cluster resources are on a node, then that node is said to be passive. A node is active if there are cluster resources on it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

swekik
Posting Yak Master

126 Posts

Posted - 2008-10-07 : 14:27:09
Two instances are there,one instance running on one node,another instance is running on another node.

If same resources are running on both the nodes then its Active/active??? other wise Active/passive?

A-node B-node

D: D:
E: E:
F: F:


Am i correct?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 14:29:24
If you have a SQL Server instance running on each of the nodes, then it is active/active.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

swekik
Posting Yak Master

126 Posts

Posted - 2008-10-07 : 15:00:27
is there any command to determine whether it is active/active or active/passive??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 15:22:41
You can determine it from the cluster administrator exe. I'm not sure that there is a simpler way, but I'm sure Google would be your friend here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2008-10-07 : 17:05:43
quote:
Originally posted by swekik

is there any command to determine whether it is active/active or active/passive??



There is no switch/button/click-me-here option to tell a cluster that it's active/passive or active/active. It's a term used to identify physical cluster implimentations.



Your friendly High-Tech Janitor:

http://grayburn.wordpress.com
Go to Top of Page
   

- Advertisement -