asked on

How do I setup a Active Active Cluster in Windows 2003?

I'm trying to setup a Microsoft Cluster Active Active for my employere. Despite all the warnings about active active they still want to push forward. This will be a 2 node cluster with identical hardware utilizing zoned san space. The intial cluster is in place (Active Passive) I need to add the resources to the 2nd node. I keep running into problems with differnt errors. Is there a step by step guide on how to setup a active active. I apologize for my lack of knowledge. I've tried ot search the net for this information but have had little success. I'm unsure on how the grouping should be setup. I have 2 separate drives in different groups. How does the quorum share or does it need to be listed in the 2nd node.. Eventially they will be using this cluster for SQL. Any Help is appreciated.

StuFox100

I am not 100% clear on what you mean by adding "the resources to the 2nd node"? Are you trying to run the same DBs on both servers? If so this will never work.

Active/Active Clustered SQL is not quite what it means - the active/active means that both nodes are serving SQL but usually server different DBs. You split the backend disk between the nodes and load share - if you have a DBA they should help you decide what DBS are best suited to be together on what nodes.

The advantage is that when one of the nodes fails all services run of the other node and keeps working.

I hope this makes it clearer...
Cheers
Stu

jmatteol

ASKER

Stu,

Thanks for the response. To make things a little clearer. We are setting up the cluster to turn over to SQL DBA's. There will be 2 different Databases on this Active / Active Cluster. In regards to setting up resources on the 2nd node. I mean should there be a 2nd resource group for node 2 housing Network Name and IP Address so that the active active ends up with 2 Virtual Servers. My problem in a nutshell happens when I try to add the Network Name to the 2nd node in a separate resource group for node 2.

Thanks Again for your help.
jmatteol

ASKER CERTIFIED SOLUTION

jmatteol

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial