currently we use Log Shipping between our Production and Contingency database servers.
The log shipping between these 2 servers occurs every 15 minutes so in the event of having to bring the Contingency server ‘live’, only a maximum of 15 minutes data will be lost.
In an effort to increase high availability of our Clarity application we are exploring the possibility of using database mirroring (SQL 2008)
Has anyone else had any experience using this method with Clarity?
Thank you for any advice or pointers that you can give.