I think I was able to convince my cow-erkers that jamming all the databases on one server is a good idea. So, our setup will be something like this:
Production - SQL 2014 Enterprise Standby - SQL 2014 (with automatic failover from Production) (I think I can get this license free if I get SA on the Prod server, right?)
Then, I was going to have a separate server off site, but ideally I'd like that to be a clone of the production server (security, databases, the whole shot). I have a few questions about this:
1) Can I make this automatically failover if both prod and standby are down?
2) Can I have this use Asynchronous transactions and have Prod/Stand use Sync?
Thanks so much