Hi:
I'm trying to setup a MS Cluster but I don't know if it is feasible to
configure it in the way I think.
I have two machines with win2k server and MSSQL-2000 one of them is
currently performing as the production database and the other one is
the backup. The secondary one is keeping updated via the "Log
Shipping" technic.
We almost covered all the other possible failures of the other
components (ie: network, power, application servers, etc), the data is
maintaned in a raid which is ok but we want to cover also the
possibility of that failure too (yes, you can call us paranoids!! ).
The thing is we want to create a cluster that do not share the data,
but each machine of the cluster have thei own set of the same data.
My intention is to configure the cluster to detect a failure of one
machine and initiate the failover to the remaing one using the
appropiate scripts related to the promotion of a secondary server
keeped updateusing "log shipping".
Have anyone some experience with that kind of solution ??
Thanks in advance
Leonardo