I am trying to come up with a solution for a client and after reading multiple sources of information I am still not 100%.
What I am trying to achieve:
They will have an SQL 2008 R2 Server (edition to be decided) hosting 2 databases: Sage 200 and BES.
These databases should not be too heavily utilized, as Sage 200 will have a single user license and BES is only for 13-15 users.
We need to ensure near instant DR for these databases.
Was going to propose setting up a second SQL Server at a DR site (have one available) with database mirroring over a VPN. 10Mb connection at DR site and 100Mb connection at HQ.
The idea is should HQ go down, we can make the DR SQL the principal database until HQ comes back up, then failback (manual/automatic failover not too important at this stage)
Questions I have are:
-Will this work, in principal?
-Is there a better way to achieve this?
-Any "gotchas" to look out for?