SQL2005 Cluster Active-Active?

[Jamfool]

is it possible to install this in an active-active cluster setup? and has anyone done it?..got notes info on it?

general advice on 2k5 clustering?

 

[mrdenny]

Yes. I have an active/active cluster with two nodes and two SQL instances setup. Each active on there own node.

If you mean can you have a single SQL instance spanning both physical nodes, then no.

SQL 2005 clustering is very easy to setup (We have 4 setup).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Jamfool]

great thanks for the answer mrdenny surprising how little information there is regarding active-active clustering.

when installing 2k5 in active active mode on a 2 node cluster is there anything to be careful of?

Ive been thru the ms courses on installing it, but we will be doing a test run thru later today on some dev boxes.

 

[mrdenny]

There shouldn't be to much to worry about. Same things as with SQL 2000. One will need to be a named instance.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com