Does anyone know of a good solution for for data replication and failover for SQL 2000. We are currently using Double Take for replication and failover, however without having a "body" dedicated to constantly looking at the software if something was to happen " and it did " we are unable to determin which server is the primary and the same for the failover. I have looked into Clustering for SQL 2000, but it seems to be a good solution for hardware failover but not data replication...

Any suggestions??