If the database is only for non-production use (development and testing), you can use Developer Edition. Developer Edition does not have the database size limitations of Express Edition.
Ho to have more than 10gb database in sql server?
Takeshi
41
Reputation points
Hi all,
I have sql server created on my PC, but on this server is a 10GB limit of database. I need more ... do you know how to get more?
Thank you
SQL Server Other
14,494 questions
Accepted answer
2 additional answers
Sort by: Most helpful
-
Tom Phillips 17,771 Reputation points
2022-09-06T12:03:09.71+00:00 SQL Server EXPRESS edition has a 10GB limit. If you need more space, you need to upgrade to Standard or Enterprise edition.
-
Bjoern Peters 8,921 Reputation points
2022-09-06T12:21:55.173+00:00 @Tom Phillips is absolutly right, I just want to give you the link to the documentation