How to change Edition and MAX Size of a SQL Azure database

SQL Azure databases come in two editions - Web and Business.

EditionMax Size Options (GB)
Web 1, 5
Business 10, 20, 30, 40 50

How to check what's your current Edition and Max Size? Check this post here: http://azure-howto.blogspot.com/2011/10/how-to-check-edition-and-max-size-of.html

A database gets created as Web edition with 1GB as the max size if you execute just a CREATE DATABASE DATABASE_NAME. We could specify the desired edition and max size during the creation of the database or we could alter the database later.


1. Example for CREATE DATABASE (SQL Azure Database)
http://msdn.microsoft.com/en-us/library/windowsazure/ee336274.aspx

CREATE DATABASE DATABASE_NAME
(EDITION='WEB', MAXSIZE=5 GB)

 2. ALTER DATABASE (SQL Azure Database)

ALTER DATABASE DATABASE_NAME
MODIFY (EDITION='BUSINESS', MAXSIZE=50 GB)

2 comments:

Anonymous said...

CREATE DATABASE syntax is now at http://msdn.microsoft.com/en-us/library/dn268335.aspx
ALTER DATABASE syntax is now at http://msdn.microsoft.com/en-us/library/ms174269.aspx

sfp777 said...

There is so much misinformation and so many bogus products surrounding penis enlargement that when they discover the solution, no one will believe. So here goes; any male can permanently increase length and girth in the same way a bodybuilder adds mass and becomes larger. As you stress tissue, the body goes into a natural process of creating new cells making you larger. The question is not whether permanent enlargement is possible but instead, how do you safely stress penile tissue to promote cell growth? The answers can be found at MagnumRings.com

Post a Comment

Please let me know if you find it useful!