We want to set up a real-time failover server for a critical SQL application that runs on a dedicated Windows 2003 server. Our initial thought was to simply use SQL replication to another server, but then we learned that there are directories of accompanying application files that must be replicated as well. We are aware of clustering, and third-party applications such as DoubleTake, but we are hoping that there may be a less expensive alternative. Placing the files on a network storage device would work, but that still leaves a single point of failure.
What do the experts say?