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

Question

Hallo,

our database is Premium P11, 1750 DTUs, 3 TB.
During an index rebuild after 24 h. is the message:

Msg 40544 The database has reached its size qouta.

There was enough space free.

thanks.

Answer 1

One thing is the limit of the tier and another thing is the maximum set to the database when it was created. That may be the scenario.

For example you know the limit for the tier is 4,096 GB or 1,024 GB, but the database can have a maximun size set that is lower than the limit of the service tier. You can query that maximum size with below query

SELECT CAST(DATABASEPROPERTYEX ('Alchavo30' , 'MaxSizeInBytes' ) as bigint) /1073741824 

You can change that maximum size using an ALTER DATABASE statement.

This error may also appear when creating temporary tables on Azure SQL as explained here.