I have two servers that replicate data. I need to have the ability to failover to the second remote server if the first fails. dns points to the first server. Any suggestions on how to accomplish this task. Both servers are windows 2000 server std and 2000 SQL server std.
Need to implement this yesterday.