The database ‘jbswiki’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.

-> Insert statements were failing with below error,

Msg 40544, Level 17, State 2, Line 12
The database ‘jbswiki’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.

-> Logged into the Azure portal and checked the Azure SQL Database. On the overview tab, I was able to see that the database was full,

-> The resolution for this will be to drop some unwanted objects from the database of increase the database size. I decided to increase the database size from Azure portal.

-> On Azure Portal, Open the Azure SQL Database and then navigated to “Compute + storage” and then increased the size from 500 MB to 1 GB and clicked on save,

-> Once this was done. Insert statements started working fine.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply