Node A and Node B (sql server 2000) are being replicated to each other
serving data partitioning.
What are the options to set up HA clustering and which one is the most
economic one?

Appreciate any help.

I think you want a cluster. Here are a few guides for you:

General Clustering information
http://www.microsoft.com/ntserver/su...tering_faq.asp
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/windows2000...ustersteps.asp

SQL Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
http://www.microsoft.com/usa/webcasts/ondemand/1883.asp (Webcast)

Now for the price issue. HA and price never agree. You can either have one
or the other.

My website also has a ton of clustering information on it.
Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Wen Chang" <WenChang (AT) discussions (DOT) microsoft.com> wrote