SQL Server Clustering: Do's, Don'ts and Basic Warnings

This document was new to me, perhaps it's new to you as well:

SUMMARY

This article describes some important do's and don'ts for using SQL Server clustered servers with the different versions of SQL Server.

Important All customers who are still using clustering with SQL Server 6.5 and SQL Server 7.0 should upgrade to SQL Server 2000 or SQL Server 2005 as soon as it is feasible to do so. The following tools, features, and components are supported with failover clustering in SQL Server 2000 Enterprise Edition:

• Microsoft Search service

• Multiple instances

• SQL Server Enterprise Manager

• Service Control Manager

• Replication

• SQL Profiler

• SQL Query Analyzer

• SQL Server 2005 Analysis Services

Note Microsoft Product Support Services (PSS) supports SQL Server Failover Clustering as described in the following Microsoft Knowledge Base article:

327518 The Microsoft SQL Server support policy for Microsoft Clustering

SQL Server Enterprise Edition must be installed for support if SQL Server is being used together with Microsoft Cluster Server (MSCS).

See the rest of the knowledge base article for the goodies.