SQL Azure: What will happen if size of my SQL Azure get 5GB?

Question

Hi all, I need to know what will happen when a database in SQL Azure exeeds its size. For example I defined a 1GB database and this is going over its size limit. Will it change to a 5GB database?

Answer 1

I believe the answer can be found here: http://msdn.microsoft.com/en-us/library/ee336245.aspx#dcasl Which means that the database will not automatically grow to 5 GB, but you will receive an error and you have to manually alter your database to change the MAXSIZE of your database

Answer 2

You won't be able to go over 1GB unless you specifically allow for it. You'll actually get an error code when attempting to go beyond 1GB.

To increase max size, execute this T-SQL: ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=5GB)

For more info about altering database sizes, see this blog post.