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  General SQL Server Forums  New to SQL Server Programming  Is this cluster configuration possible in SQL Serv

Author  Topic  Elidas Starting Member 33 Posts Posted - 2008-01-29 : 05:32:58 Hi, could someone tell me if this configuration is possible? 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 with 3 instances at the same time. Help please? thanks