• I think you need to do a lot more research. Start with Book Online, after that look for the HA/DR whitepapers from Microsoft. Alternately, suggest to your client that they hire someone with HA/DR experience to design and implement the solution.

    HA/DR is not an area that you want to make mistakes in, mistakes cost money, they cost jobs.

    Edit: You also absolutely have to design it according to the client's RPO and RTO and then implement a test setup and see how well it works.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass