• The principal role needs to be taken over without manual intervention by the (DR)mirrored database - although the original principal database is up from a SQL perspective and yet unreachabe for the application server or the web-frontend used by the board members.

    A variation of Merge replication may be the solution - but the material I am reading is not clear enough.