restore database

  • mukesh28info

    SSC Journeyman

    Points: 84

    System.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.Express.Smo)

  • spaghettidba

    SSC Guru

    Points: 105661

    SQL Server Express has a limit of 10 GB per database.

    Actually, in SQL Server 2005 the limit was 4 GB, so you must be using some version from 2008R2 up.

  • mukesh28info

    SSC Journeyman

    Points: 84

    we use window 2007,

    can i used window server 2008 for solve this.

  • Gail Shaw

    SSC Guru

    Points: 1004424

    No such version as Windows 2007...

    The size limit in SQL Express for all versions 2008 R2 and above is 10GB. If you need a larger DB than that, you need to purchase a licence for one of the paid editions of SQL, probably Standard edition. (or developer if this is a development-only environment)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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