CODEWITHSUNDEEP
azureazure-sql-database
Joseph Sturtevant
Joseph Sturtevant

Reputation: 13360

How to Resize a SQL Azure Database

How do I resize my SQL Azure Web Edition 5 GB database to a 1 GB database? I no longer need the extra capacity and do not want to be billed at the higher rate. I don't see anything in the Management Portal and a quick web search also turned up nothing.

Upvotes: 6

Views: 3023

Answers (1)

David Makogon
David Makogon

Reputation: 71025

I answered a similar question here. It should be as simple as running an ALTER DATABASE command:

ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=1GB)

Just keep this in mind: As long as your usage is <= 1GB, you'll be billed at the 1GB rate. Billing is monthly but amortized daily. So you actually don't need to reduce your max size unless you're relying on SQL Azure to prevent you from growing beyond 1GB.

EDIT: As of Feb. 2012, there's a new 100MB pricing tier (at $4.99, vs. $9.99 at 1GB). While you can't set MAXSIZE to 100MB, your monthly cost will drop if you stay under 100MB. See this blog post for more details.

Upvotes: 11

Related Questions