Create SQL Cluster VMs
I went to test SQL High Availability or Always On, it is too complicated to setup all. If there is a Wizard which will straight install SQL cluster up and running with multiple VMs sharing same storage and datacenter would be helpful.
If there are pre configured services like,
- SQL Cluster (number of nodes)
- SQL Replicated VMs, First Primary, Second Merge Replicator or whatever. We can choose number of replicators.
- Setup two VMs or more with Mirroring, Replication, Logshipping etc, all configured once and up and running.
- Auto log backup SQL to Azure Storage every 15 mins with daily full backup service. This is now possible with SSIS in SQL 2014.
This automated deployment of multi-VM solutions is something we would like to add to IaaS.
Thrity Kasad [MSFT] commented
The SQL Server - AlwaysOn template is now available in the portal gallery. Details can be found here - http://blogs.technet.com/b/dataplatforminsider/archive/2014/08/25/sql-server-alwayson-offering-in-microsoft-azure-portal-gallery.aspx