Could not allocate space for object in database because the 'PRIMARY' filegroup is full

Question

Hello team,

We are currently running mssql express server edition - t3. small with storage of 300GB autoscaling up to 3000GB.
We ran into this error - Could not allocate space for object in database because the 'PRIMARY' filegroup is full, and when we scaled the storage up then we encountered this limitation -  CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Please assist with a way to resolve this issue and bypass this limitation as it is affecting a production database.

Gary Mclean · Accepted Answer

You need to change your SQL Instance type to Web or Greater. 
SQL Express is limited to 10GB which you have now reached

Olive · Answer

Thanks for the response. I have taken a snapshot of the express sql db and there are no options to restore to a standard sql db contrary to a similar question answered here - https://aws.amazon.com/blogs/database/modify-an-amazon-rds-for-sql-server-instance-from-standard-edition-to-enterprise-edition/

Please assist with next steps to perform this upgrade Enter image description here

Please assist with next steps to perform this upgrade
![Enter image description here](/media/postImages/original/IMzm5c_gEQQFWoW3J2o6z5TA)

Could not allocate space for object in database because the 'PRIMARY' filegroup is full

Add your answer

Relevant content