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

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.
9,725 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Bruce ( 35,416 Reputation points

    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 No comments

  2. Erland Sommarskog 77,496 Reputation points MVP

    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 No comments