Database Size on SQL Azure

347450 pts.
Tags:
SQL Azure
SQL Server 2008 R2
What’s the max size database we can have on SQL Azure?

Answer Wiki

Thanks. We'll let you know when a new response is added.

A single database can be as large as 10GB and you can have as many databases as you want. The max size will increase to 50GB by June 2010.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    There are currently two database sizes available. 1 Gig and 10 Gig.
    66,140 pointsBadges:
    report
  • Usm
    By default, SQL Azure supports up to 150 databases in each SQL Azure server, including the master database. You can create up to 149 databases in each SQL Azure server. An extension of this limit may be available for your SQL Azure server. For more information, contact a customer support representative at the Microsoft Online Services Customer Portal. SQL Azure provides two database sizes: 1 GB (Web Edition) or 10 GB (Business Edition). If the size of your database reaches its MAXSIZE, you will receive an error code 40544. When this happens, you cannot insert or update data, or create new objects, such as tables, stored procedures, views, and functions. However, you can still read and delete data, truncate tables, drop tables and indexes, and rebuild indexes. If you remove some data to free up your storage space, there can be as much as a fifteen-minute delay before you can insert new data. Check this Link http://msdn.microsoft.com/en-us/library/ee336245.aspx
    240 pointsBadges:
    report
  • ITKE
    [...] Database Size on SQL Azure asked by a Microsoft Chat Participant and answered by Microsoft, MrDenny and [...]
    0 pointsBadges:
    report
  • ITKE
    [...] Database Size on SQL Azure asked by a reader, answered by MicrosoftExpert and discussed by Mrdenny and [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following