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.

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

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

相关内容