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


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.

asked 3 months ago474 views
2 Answers
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

profile picture
answered 3 months ago

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 -

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

answered 3 months ago
  • Just trying myself.. give me 30 mins

  • Your right, doesnt allow you.. How about a native SQL Backup and Restore? Thats a lot of work I know

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions