Share via

I'm trying to restore sql instance that is about 100gb and there is this issue of limited

Arkadi 0 Reputation points
2026-06-13T02:38:04.01+00:00

I'm not export, I know basics how to do in via SQL Management Studio and I get this message: 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.Smo)

Can someone direct me how to resolve it please?

SQL Server Database Engine
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2026-06-13T08:55:15.7333333+00:00

    The reason for this error message is that you are trying to restore the database on an instance of SQL Server Express Edition, which up to SQL 2022 had a limit of 10 GB. This limit was increased to 50 GB in SQL Server 2025 Express Edition.

    There are two ways to resolve the problem. One is to restore the backup to a different edition of SQL Server. If the purpose of the restore is testing or your own education, you can use Developer Edition which has no limits, but just like Express Edition it is free. However, in difference from Express Edition it is not licensed for production usage, so you need be careful. If the database is intended for production use, you need to use one of Standard or Enterprise Edition, which both come with a hefty license fee.

    The other alternative is to upgrade to SQL Server 2025 Express Edition, and this will work if the size of the database is in the range 10 to 50 GB. If the database is bigger than 50 GB, this alternative will not help you.

    You find downloads for SQL 2025 here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads.

    If you want to find downloads for Developer Edition for older versions of SQL Server, I refer you to Google (since I don't know exactly which version you want).

    Was this answer helpful?

  2. AI answer

    2026-06-13T02:38:13.67+00:00

    The error indicates that the SQL Server edition in use enforces a hard limit of 10,240 MB (10 GB) per database. This is the limit for SQL Server Express. A 100‑GB database backup cannot be restored on an instance that is restricted to 10 GB per database.

    To resolve the issue, use one of these approaches:

    1. Restore to a non‑Express edition
      • Install or use an existing instance of SQL Server Standard, Enterprise, Developer, or another edition that does not have the 10‑GB per‑database limit.
      • Connect to that instance in SQL Server Management Studio (SSMS).
      • Restore the 100‑GB backup there using the normal RESTORE DATABASE process.
    2. Move data in pieces to stay under the limit (only if absolutely necessary)
      • This is only viable if the target must remain SQL Server Express and the total data per database can be reduced to ≤ 10 GB.
      • Restore the backup on a higher‑edition instance.
      • Use tools such as scripts, bcp, or the Import/Export Wizard from that higher‑edition instance to move only a subset of data into one or more Express databases, ensuring each database stays below 10 GB.
    3. Verify storage and file layout if restoring to Azure SQL Managed Instance
      • If restoring to Azure SQL Managed Instance on the General Purpose tier, ensure that the instance has sufficient storage and that the total size and number of database files will not cause the instance to hit the 35‑TB Azure Premium Disk limit, which can also cause CREATE/RESTORE failures even when the logical database size seems small. In that case, reduce the number of files or adjust file sizes before restore.

    The core fix for the specific error message is to restore the 100‑GB database on an edition of SQL Server that does not enforce the 10‑GB per‑database limit.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.