I'm looking for advice on the best HA/DR strategies for SQL Server. Currently I'm using Express edition with backups being copied over a the WAN to a remote site and being restored.
The SQL Express instances are hosted on a virutalised server (currently VMWare) on a box with direct RAID storage.
I'm keen to reduce the potential data loss and improve the recovery time from what the current solution is. I see a few options to help this.
1) Move to SQL enterprise and use replication
2) Move data to an iSCSI SAN and replicate the virtual disk containing SQL Data, then use a VMotion or XenApp equivilant to move from one site to the other. (I don't know if this will work from a SQL server transactional perspective)
3) Cluster virtual machines across the WAN link.
Currently the WAN link is 10Mb, and I would be reluctant to increase this - so I'm curious to find which solution will give best bandwidth utilisation, the best reliability and be most cost effective.
I am open to other suggestions as well.