Error message when restoring a SQL Server database

Tags:
SQL Server backup
SQL Server database
SQL Server errors
SQL Server restore
This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You are trying to restore a database to SQL Server Express which is to large to attach to a SQL Express database.

SQL Server Express edition has a size limit of 4 Gigs. You are trying to restore a database which is larger than this.

You will need to shrink the database then back it up again and restore it to the Express edition, or purchase one of the pay editions of SQL Server which allows for databases larger than 4 Gigs (the Express edition is the only one with a size limit).

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Heidi
    I have upgraded to the sql server express 2008 r2 edition and it still won't let me restore a db larger than 4 gb. What do I need to do to resolve this?
    10 pointsBadges:
    report
  • Denny Cherry
    What's the error message that you are getting when restoring your database?
    66,290 pointsBadges:
    report
  • KeithO
    I am getting the same error in SQL server 2008 express: System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Smo) I thought SQL 2008 was supposed to handle up to 10 Gb DB's?
    10 pointsBadges:
    report
  • Darryn
    No, express 2008 is still limited to 4gb. http://www.microsoft.com/sqlserver/2008/en/us/express.aspx (look for limitations near end of page).
    765 pointsBadges:
    report
  • Denny Cherry
    SQL Server 2008 R2 increased the limit to 10 Gigs, the original release of SQL Server 2008 (also called R1) is limited to 4 Gigs.
    66,290 pointsBadges:
    report
  • HarishH
    I have Sql Server 2008 R2 but I also get same error while restoring the 10GB database.
    10 pointsBadges:
    report
  • Denny Cherry
    HarishH, Your database is probably just over 10 Gigs, and 10 Gigs is the limit on the database size for SQL Server 2008 R2 Express edition. You'll need to either shrink the database then back it up again and attempt to restore it, or restore it to an edition other than Express (Express is the only one with a size limit). Denny
    66,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following