Restore error

  • Hello,

    Iam restoring the databse on sql serrver Express edition and am getting the following error.

    Restore failed for SQL\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)

    Can any one help me with this?

    Thanks,

    Rahul.

  • The error is saying that the database you are trying to restore is larger than the 4gb limit SQL Express enforces.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • So, can you tell me in what way i can restore it? is it not possibe?

    thanks.

  • The error message is being raised because of the SKU limitation of Express. SQL Server 2005 Express has a SKU limitation of 4GB for the database size. If you want to use a database larger than 4GB for a SQL Express instance, then upgrade to SQL Server 2008 R2 Express which has a database size limitation of 10GB.

    This posting is provided "AS IS" with no warranties, and confers no rights.
    My Blog: TroubleshootingSQL
    Twitter: @banerjeeamit

  • In Express edition you can not restore a backup which is having more than 4gb. You may required to reduce the size of the database by removing unwanted data and take the backup again with less than 4 gb and restore in express edition instance.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply