• database mirroring would be the best solution for you here. Replication is more associated with replicating parts of a database rather than the whole database

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉