I was reading how SQL Azure ("out of the box") supports either Web
(1-5GB) or business (1-50GB) databases. Well, we have several databases that
What is the proper "Azure" understanding of these constraints?
1. We need to contact Microsoft to buy extra space if we wanted such a database in
2. At this time, Microsoft SQL Azure simply does not support a single database
larger than 50GB?
3. There is some technical reason why databases exceeding 50GB are not good
candidates for SQL Azure?
SQL Azure supports databases of up to 150GB as of November 2011 (http://msdn.microsoft.com/en-us/library/windowsazure/ff602419.aspx) and databases as small as 100MB since February 2012 (http://blogs.msdn.com/b/windowsazure/archive/2012/02/14/announcing-reduced-pricing-on-sql-azure-and-new-100mb-database-option.aspx).
I encourage you to look at the second link; pricing for SQL Azure databases has also changed.
Herve Roggero, MVP SQL Azure Co-Author: Pro SQL Azure http://www.herveroggero.com
additional to the information provided by Herve you should also have a look at federation in SQL Azure.
Best Regards. Please Mark Answered, If my solution solves your problem.