Menu
I need to know what will happen when a database in SQL Azure exeeds its size. For example I defined a 1GB database and this is going over its size limit. Will it change to a 5GB database?
617
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.
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. Workloads requiring up to 2 TB storage can now reduce costs by not having to increase the compute size beyond 8 vcores.
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.
With Azure SQL Database, you can set a long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups using the Azure portal, Azure CLI, or PowerShell.
You won't be able to go over 1GB unless you specifically allow for it. You'll actually get an error code when attempting to go beyond 1GB.
To increase max size, execute this T-SQL:
ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=5GB)
For more info about altering database sizes, see this blog post.
188
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
