We are implementing a new HA/DR solution, and I am asking for guidance on the best (not too expensive) options for having a warm or even hot standby of the entire server.
Setup: We will have two new physical servers at the same colocation facility, each running a windows 2012R2 VM with SQL server 2012 (or maybe 2014) Standard edition on it--and under OpenStack, in case that matters. There are only 2 databases to be synched with the target VM, and the largest is under 10 GB. Not a heavy load. I should also mention that this sql server instance is a publisher in replication to 3 other servers.
If VM1 fails in some way, we'd like to get VM2 up and running in less than 30 minutes--much faster would be much better.
What are my 'best' options? I'm leaning towards DB mirroring or even log shipping. Googling around I have found the following:
• VM-level replication (but our network guy feels this is not that reliable). Seems conceptually simpler.
• Mirroring the 2 databases, with auto failover feature (we are using Standard edition)
• Log shipping
• Always on AGs? I don't think we can use these with Standard Ed.
I realize the mirroring/log shipping solutions require many other external objects to be synched up as well (logins, credentials, sql agent jobs, you name it…)
Thanks for any guidance here!