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

0

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.

Olive
asked 3 months ago474 views
2 Answers
1
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
EXPERT
answered 3 months ago
0

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

Olive
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