How does failover clustering work in SQL 2005? And how does it compare with the failure support in Oracle and DB2?
The failover clustering functionality in SQL Server 2005 has been extended in various ways. First of all, SQL Server 2000 running on Windows 2000 Datacenter was limited to a four-server cluster. SQL Server 2005 running on Windows 2003 Server can now support up to eight nodes (depending on the edition of Windows 2003.) Failover is now also supported for a wider variety of services. Analysis Services, Notification Services, replication, and SQL Server Agent are all cluster-aware in SQL Server 2005. This is a major factor for those organizations that utilize these features and need to maintain high availability! But the biggest improvement in terms of database availability is not from the failover clustering side at all. A new feature called “Database Mirroring” will prove to be a much more interesting way of maintaining uptime. This feature can be thought of as a more real-time form of log shipping. Transactions are broadcast continuously from the active node to a waiting database on ano
