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)

4 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

Tripu Design said...

This is an amazing blog, thank you so much for sharing such valuable information with us.
Visit for best logo and brochure designing services at- brochure designer in gurgaon.
Thank you for sharing your wonderful information. for professional graphics,
work contacts me. I am a freelance designer in gurgaon.
Freelance Graphic Designing
Freelance Catalogue Designing in delhi
Freelance Catalogue Designing in gurgaon
Freelance Brochure Designing
Freelance Label Designing
Freelance Banner Designer
Freelance Poster Designer
graphic design services in delhi
graphic design services in gurgaon
Freelance Catalogue Designing in delhi
Freelance Catalogue Designing in gurgaon
Freelance Brochure Designing
Freelance Label Designing
Freelance Banner Designer
Freelance Poster Designer
graphic design services in delhi
graphic design services in gurgaon
Freelance Catalogue Designing in delhi
Freelance Catalogue Designing in gurgaon
Freelance Brochure Designing
Freelance Label Designing
Freelance Banner Designer
Freelance Poster Designer
graphic design services in delhi
graphic design services in gurgaon
Freelance Catalogue Designing in delhi
Freelance Catalogue Designing in gurgaon
Freelance Brochure Designing
Freelance Label Designing
Freelance Banner Designer
Freelance Poster Designer
graphic design services in delhi
graphic design services in gurgaon
graphic designer in gurgaon
freelance graphic designer in gurgaon
freelance graphic designer in gurgaon
freelance graphic designer in gurgaon
freelance logo designer in gurgaon
freelance logo designer in gurgaon
freelance web designer in gurgaon

Parul Pathak said...

This site helps to clear your all query. pdusu ba final result 2021
Mizoram university bcom exam result 2021 This is really worth reading. nice informative article.

Post a Comment

Please let me know if you find it useful!