Perry Whittle (5/26/2011)
Firstly there is no such thing as anActive\active\active\passive cluster.
A cluster is either active\active or active\passive.
I'm not sure why you'd say there is no such thing as an Active/Active/Active/Passive cluster. I've built a few of them in the last year. Standard Edition has a limitation of 2 nodes in a cluster, but Enterprise and Datacenter editions support as many cluster nodes as the OS allows.
Features Supported by the Editions of SQL Server 2008 R2
You can have 4 cluster nodes, and 3 instances of SQL installed on them, with three nodes owning a different SQL instance and your failover node in standby.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]