Earlier this month Amazon announced that you can now use RDS with SQL Server.  I have been using RDS for MySQL about 9 months now and really like.  It automates many of the administrative tasks, but gives you a backup within an availability zone.  This will allow me to suggest AWS as a hosting option for some of the high availability .NET apps that I work on.