SSMS says I need a license to work with over 10gb. I'm trying to do local testing on a sql server db using ssms. Is there a way to fix this?

David Link 0 Reputation points
2023-05-24T16:44:57.75+00:00

Microsoft.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft.SqlServer.SmoExtended)

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,703 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 55,686 Reputation points
    2023-05-24T18:04:57.2333333+00:00

    no. you should build a test database on the a supported server.

    you can either copy tables with restrictions or restore and delete data.

    back this up and an restore on your limited box.

    0 comments
  2. Erland Sommarskog 100.9K Reputation points MVP
    2023-05-24T21:34:47.6333333+00:00

    First SSMS does not say anything. The message comes from SQL Server. SSMS is only the tool you use to talk to SQL Server.

    Apparently, you have SQL Server Express Edition and Express is limited to a database size of 10 GB. If is after all a free edition that is licensed for production use.

    If this is only for testing you can download and install Developer Edition, which is also free and which has no limits, but which is not licensed for production use.

    You can not restore only a part of a backup. As Bruce says, you could restore on a different edition, delete tables you don't need, shrink the database in size below 10GB and take a new backup. Or copy data to a new database.

    0 comments