We are running SP2010 enterprise with 4 servers (APP1, APP2, WEB1, WEB2) and 1 SQL cluster.
In order to provide DR ability, we design to move one server (APP2, which is a VM instance) to DR data center. We will setup a new SQL server at DR site with the same version as production. Finally, we will backup all databases daily and restore to DR SQL server. The DR SQL server will be added to each configuration DB and content DB as "failover server".
In case of production site outage, we will:
- Make sure APP2 is connecting to the DR SQL server (I assume SharePoint will auto change to failover server when production SQL is down?)
- Turn on all service/service application on APP2.
- Point all web request to APP2's IP.
Is it a possible plan?
P.S. We have considered several alternatives like setup mirroring, log ship, etc but they are banned due to technical restriction and budget.