This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 94%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
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)
Can I import a portion of the data from the .bak so that it is under 10gb?
Hi @David Link
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @David Link
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
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.
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.