Skip to main content

SQL Azure Error - 40544

If the size of your database reaches its MAXSIZE you will receive an error code 40544.

You cannot insert or update data, or create new objects (such as tables, stored procedures, views, and functions).

To fix this issue either increase your database size or delete data.

For increasing/decreasing SQL Azure database size, you can use this command on the Master database.

Alter DATABASE database_name MODIFY (MAXSIZE = {1|5|10|20|30… 150}GB);

example:

ALTER DATABASE sampleDB MODIFY (MAXSIZE = 5gb);

Comments

Popular posts from this blog

User unable to login to Azure instance (VM role, Worker Role, Web Role)

Error: The user’s account has expired.Reason: 1. By default RDP on Windows Azure instance is valid for a period of 1 year. 2. Date mentioned for “RemoteAccess.AccountExpiration” value in the configuration file (.cscfgfile) is passed. Resolution: 1. Editing the configuration file. Select the deployment and click on ‘Configure’ > ‘Edit current configuration’ and change the “RemoteAccess.AccountExpiration” value to a future date. 2. From the Management Portal UI. Select the desired role, click on configure and select a future date under “Expiration time”, click on OK.