InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:30:32 GMT20http://www.sqlservercentral.com/Forums/Topic1430271-3154-1.aspxThanks all for your valuable suggestion!!I found that Microsoft provides “[b]SQL Server in Windows Azure Virtual Machine[/b]” which provides full SQL Server box product features and gives the administrator full control over a dedicated SQL Server instance and cloud-based VM.Can you please suggest some pros n cons of [b]SQL Server in Windows Azure Virtual Machine[/b] over [b]EC2[/b]?Fri, 15 Mar 2013 06:59:59 GMTTarun Jaggihttp://www.sqlservercentral.com/Forums/Topic1430271-3154-1.aspxI would go RDS if you want "Failover Clustering", while it is not true failover clustering, RDS allows the option for having the server in multiple AZ within a region so if the AZ dies it moves to another. EC2 you would have to put something like mirroring in place, so you would need 2 EC2 hosts.Backups you will need to do yourself and depending on what your strategy is, you will need S3 storage or pull it to your office to back it up as that is something which Amazon doesnt do.Jeremiah Peschka did a good article on Brent Ozar's site on EC2, might be worth a read[url]http://www.brentozar.com/archive/2011/09/sql-server-ec/[/url]Wed, 13 Mar 2013 03:57:53 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1430271-3154-1.aspxWe are planning to move our warehouse database (which is around 1TB) to the cloud. Currently we are looking at Amazon RDS and EC2 (as these supports multiple features which SQL Azure doesn't support). Also we need high availability along with failover cluster, and backups. Can you guys please suggest when to use RDS and when to use EC2?Wed, 13 Mar 2013 03:53:14 GMTTarun Jaggi