Is it possible to upgrade the 10 gigabyte size of SQL Server Express?

19519984 0 Reputation points
2023-08-01T11:26:23.9766667+00:00

I have created a system with C# and SQL Server Developer, the system runs on a local computer.

I need a storage between 20 to 50 gigabytes inside the SQL Server.

What do I have to do ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,323 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 39,181 Reputation points
    2023-08-01T11:43:09.4633333+00:00

    The max database size of 10 GB for the free Express Edition is fix, you can't change.

    Purchase a standard edition.

    Or take the effort (and disadvantages) to split you data over several databases, so call "data sharding".

    https://en.wikipedia.org/wiki/Shard_(database_architecture)

    0 comments No comments