Database mirror in the cloud, where to put witness?


  • Hi,


    If I am to use database mirroring to put a copy of my DB onto a sql server hosted in the cloud where should I put the witness?  The onsite DB will be the primary server and in use most of the time, the cloud version is there for the event of total on promise failure.  Should the witness be in the cloud or on premise?



    Monday, June 27, 2011 8:36 AM