Menu
I'm currently in the middle of developing an application loosely similar to StackOverflow (question / answer based)
Initially, I was using AWS (simple db and s3) for storage, however that posed several problems, and i've opted to go with SQL - With a view to eventually hosting on SQL Azure.
I was just wondering, if i opted for the 1gb database initially, could I increase the size to the 5gb / 10gb databases later on? Or would I have to create a separate new database of this size, and port my data over?
824
Expand Databases, right-click the database to increase, and then click Properties. In Database Properties, select the Files page. To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.
When data space used reaches the maximum data size limit, either at the database level or at the elastic pool level, inserts and updates that increase data size fail and clients receive an error message. SELECT and DELETE statements remain unaffected.
To upgrade a database use the Database Scale tab in the Azure management portal. Simply select the desired service tier and performance level and then click Save. The database will stay online throughout the upgrade operation, with only a brief disconnect/reconnect occurring at the end in some cases.
Data storage limits in Azure SQL Database have increased from 1.5 TB to 2 TB for single databases and elastic pools configured with 8 and 10 vcores.
See my answer on this other SO question. In a nutshell, you modify db size with T-SQL, such as:
ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=5GB)
You can also change the size of the database through the Azure SQL portal. Simply choose the database and go to the scale tab and select the size you want.
Tada
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
