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.
| Author |
Topic |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-01-30 : 05:53:59
|
| Hi, could someone tell me if this configuration is possible in SQL Server 2000 or 2005? Machine A: Instance 1 (ACTIVE) + Instance 2 (passive) + Instance 3 (pasive) Machine B: Instance 1 (passive) + Instance 2 (ACTIVE) + Instance 3 (pasive) Machine C: Instance 1 (passive) + Instance 2 (passive) + Instance 3 (ACTIVE) I know that it is possible with 2 machines with the clasical solution of Machine1: active-passive, Machine2: passive-active, this way if one of the machines goes down the other one will take the job of both instances, but I dont know if this solution is possible in SQL server 2000 or 2005 with 3 instances at the same time. Help please? thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-30 : 11:33:24
|
| so you are just wanting to run one instance of sql on each of the 3 nodes of you cluster right? that is definitely possible with either sql 2000 or sql 2005. |
 |
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-01-31 : 03:31:44
|
| If machine A fails is there any way that the machine with more resources avaiable be the one that take the failover of machine A? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-31 : 23:53:44
|
| You have to specify preferred failover node for each instance. |
|
|
|
|
|
|
Is this cluster configuration possible?