Share via

How do I empty data the PRIMARY filegroup to allow more space for new data?

Matthew Treadway 0 Reputation points
2024-12-26T14:01:03.8566667+00:00

Hello all,

I'm currently getting a database error on my SCADA ignition client. New to the SQL world, I did see however that our max file size is 10GB for the SQL Express edition. Looking to make room for the new data coming in.

Any Insite would be much appreciated.

Thanks

DB SETTINGS

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,283 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 29,826 Reputation points
    2024-12-27T02:02:21.1933333+00:00

    Hi @Matthew Treadway

    SQL Server Express does have a 10GB database size limit.

    Take a view of the size of all tables in the database and focus on the largest ones. Consider do some clean up like delete old or unnecessary data.

    If you are dealing with a growing amount of data, it is suggested to upgrade to standard edition depending on your needs.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.