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

Igor Kosjanski 26 Reputation points
2021-12-16T19:39:46.407+00:00

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.

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 34,151 Reputation points MVP
    2021-12-16T21:24:19.373+00:00

    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.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.