I was given a spec sheet to build a sql sever environment which is highly available. I was told the servers need to be at two separate offices. Only one sever should be active at a time, but the secondary sever should always have the most recent database. Nothing is currently built. I'm up to suggestions and looking for the simplest and most economical solution.
Given the details below how can I setup a single instance sql cluster with database replication?
Primary and secondary site are virtualized with VMware
Primary and secondary site are utilizing two different vendor SANs
Windows Server 2012 R2 Standard on both sides to host SQL
SQL Server 2008 R2 Standard will be on both Windows servers