• The important which I had missed is - Sql Server has the database and log files locked as long as the Sql Server service is running. It would not be possible to copy/replicate these files when they are in locked state. So all the scenarios which we had proposed earlier would fail. Its a shame that I had not thought of that.

    The only way implement DR is to use in-built Sql Server features namely Log-Shipping or Mirroring. Probably Log-Shipping would be a much better, since this is a remote DR site, nearly 200 miles away from the production Data-Centre. We will install a new instance on this site and implement log-shipping for all the 20 DBs one by one.

    THanks all for your support.