Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). SQL Server 2000 Clustering Pros and Cons   Article Abstract: In this article, Alexander Chigrik describes the pros and cons of SQL Server 2000 clustering.   Read this article...

Related Articles - For Members. All Articles By Author SQL Server 2005 Clustering Optimization Tips (Part 1) Preparing to Install Failover Clusters SQL Server 2005 Clustering Optimization Tips (Part 2) SQL Server 2000 Clustering Optimization Tips Understanding Failover Clusters SQL Server 2000 Cluster Troubleshooting Checklist: Preparing to setup SQL Server 2000 clustering Webchat Transcripts: Clustering SQL Server 2005 Cluster Troubleshooting Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

RE: SQL Server 2000 Clustering Pros and Cons
(posted: 10/27/2004 9:23:02 AM)
CON : A SQL 2000 SP3 Machine cannot be joined to an existing cluster. This can make FullText maintenance a nightmare for extensive FT Indexes.

Does anyone have experience with the PolyServe Clustering solution? http://www.polyserve.com I've been considering this solution.

I am excited about FullText enhancements with SQL 2K5, but I've also heard that clustering is not changing much or at all with SQL 2K5.

RE: SQL Server 2000 Clustering Pros and Cons
(posted: 10/27/2004 6:00:46 PM)
Clustering does not protect against logical data corruption or failure of the disk pack, as the same disks are shared between both nodes.