Hot answers tagged replication
Point 2, can be addressed by using AWS RDS to back up data for you. Otherwise, you manually need to create a snapshot of your EC2 instance but this involved a tiny bit of downtime and will cost money to store on S3. Point 1, just restore the database Either way, you want a high level of functionality that you don't want to pay for, so our options for ...
Agreed -- db mirroring would be highly unlikely in this situation since it works best if it's persistent and would need manual intervention every time you turned your desktop system on. Snapshot Replication is the only realistic option in the replication world, and there's no benefit gained over using a simple database backup and restore or AWS snapshot.
I been using Veeam in our HP dl380 environment for 2 years now. It works perfectly across all networks, hardware, and host os. I have everything on VMWare and as long as your replication site is in VMWare you can use whatever hardware you want. I currently run a three tier system using Veeam backup onsite, replication offsite, and backup copy over a VPN ...
This isn't really an Azure question, its a "how do I do SQL clustering question". You can't just share a SQL database between two VM's and it magically work, you would need to setup your VM's in a cluster to share the SQL workload between them. Clustering in Azure is slightly different than on premises as you can't use shared disk storage for clustering ...
Only top voted, non community-wiki answers of a minimum length are eligible