如何调整SQL Azure数据库的大小 [英] How to Resize a SQL Azure Database

问题描述

如何将SQL Azure Web Edition 5 GB数据库的大小调整为1 GB数据库?我不再需要额外的容量，也不想以更高的费用付费.我在管理门户网站上看不到任何内容，并且快速的网络搜索也没有发现任何结果.

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.

推荐答案

我回答了类似的问题

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)

请记住以下几点:只要您的使用率< = 1GB，就会以1GB的价格向您收费.帐单按月结算，但按天摊销.因此，实际上除非您依赖SQL Azure来阻止您的最大容量超过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.

编辑:截至2012年2月，新的100MB定价层(4.99美元/1GB的价格为9.99美元).虽然您不能将MAXSIZE设置为100MB，但是如果您的每月费用低于100MB，则每月费用会下降.请参阅

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.

这篇关于如何调整SQL Azure数据库的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！