Error message when restoring a SQL Server database
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 6, 2009 7:16 PM
UPDATED:
August 4, 2011 5:55 PM
Answer Wiki:
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).
To see all answers submitted to the Answer Wiki: View Answer History.
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?
What’s the error message that you are getting when restoring your database?
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?
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).
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.
I have Sql Server 2008 R2 but I also get same error while restoring the 10GB database.
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