We are going to upgrade our third party application. Also we are going to upgrade our DBMS from SQL Server 2008 R2 to SQL Server 2014 Standard edition. We also wanted to have a high availability option for our back end. The HA options available for SQL Server 2014 Standard editions are
- Log Shipping,
- DB Mirroring(safety full only),
- Alwayson Failover Cluster Instances (Node support: 2) and*
We also want to have a third box which should have the exact replica of data that is present in above two. This box will be used for reporting purpose.
Please provide the best possible setup that can be made with all the options available so that we can have best HA option and also a reporting box with synced-up data.
Note: VMs is not a problem. Currently we are allocated 3 VMs, we can go for 4 as well if needed.
It will great if somebody can provide their insights.