I have one Amazon EC2 instance of Windows Server which is running application with SQL server. Our users from On-premise use RDP to login into this server using Elastic IP and do their work. I want to have failover server (same replica) in the backup so when primary server goes down then it starts failover server automatically. Failover server should also be in different region/zone.
I want to keep backup server turned of to cut off the cost, what are the options to achieve this?