SQL Azure Database sizes......

Question

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
exceed 50GB!

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
SQL Azure?

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?

TIA,

Barkingdog

Answer 1

Hi,

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

Answer 2

Hi,

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.