SQL Server Failover Clustering is built upon the Microsoft Server Clustering Services (MSCS) on Windows so since W2K8 Server supports 16 node clustering so does SQL Server 2008.

When designed to support SQL Server, the failover cluster creates a high-performance, high-availability environment that is easy to manage.

To verify this, I registered three servers in SSMS 2008, one SQL Server 2000, one SQL Server 2005 and one SQL Server 2008. I then ran queries through the Multi-Server Query interface with a single ...

The HADR Edition come with multi-subnet clustering, so users don’t need to stretch a VLAN from one site to another; automatic failover of SQL Server instances; and a service level framework to ...