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

Arkadi 0 Reputation points

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?

0 comments No comments
Sign in to comment

2 answers

  1. Erland Sommarskog 134.7K Reputation points • MVP • Volunteer Moderator

    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).

    1. Akhil Gajavelly 1,830 Reputation points • Microsoft External Staff • Moderator

      Hi @Arkadi ,

      Thank you, Erland Sommarskog, for the detailed explanation.

      Based on the error message, the limitation appears to be related to the SQL Server edition being used. As explained above, SQL Server Express editions enforce database size limits, which would prevent restoring a database of approximately 100 GB.

      @Arkadi could you let us know:

      • Which SQL Server edition and version you are restoring to?
      • Is the target instance SQL Server Express?
      • What is the approximate size of the backup/database?

      Also, please let us know whether the information provided by Erland helped resolve the issue or if you need additional guidance.

      Thanks,
      Akhil.

    2. Akhil Gajavelly 1,830 Reputation points • Microsoft External Staff • Moderator

      Hi @Arkadi ,

      Just checking back to see whether the information provided by Erland helped resolve the restore issue.

      The error message indicates that the target SQL Server instance is likely subject to the 10 GB per-database size limit imposed by SQL Server Express. If that is the case, restoring a database of approximately 100 GB would require upgrading to an edition that supports larger database sizes.

      If you're still experiencing the issue, please share the SQL Server edition and version of the target instance so we can provide more specific guidance.

      Thanks,
      Akhil.

    Sign in to comment

  2. AI answer

    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.
Sign in to answer

Your answer