none
Error 1827: CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.

    Question

  • I now use Window XP SP2. And I've installed SQL Server 2000 and installed MSDE. How can I attached the database which size bigger than 2 GB. Anybody have any idea or solution?

    Thanks you all in advance.

    Wednesday, November 03, 2010 4:57 AM

Answers

  • You are using MSDE and therefore cannot use a database above this size. You would need to upgrade the SQL Server Edition to use a database larger than 2GB. Other options include shrinking/removing some data (i.e. data which can be archived), or breaking the database up into multiple ones. What are you using the database for?

    Another option is to upgrade to SQL Server 2005 Express which allows a 4GB user database. Of course this requires extra work, planning, testing etc...

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

     

    Thanks


    Neil Moorthy Senior SQL Server DBA/Developer
    • Proposed as answer by moort Wednesday, November 03, 2010 5:35 AM
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 4:43 AM
    Wednesday, November 03, 2010 5:32 AM
  • You will be better of intalling SQL Server 2008R2 Express Edition which is limited to 10gb database size
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 4:43 AM
    Wednesday, November 03, 2010 6:41 AM
    Moderator

All replies

  • You are using MSDE and therefore cannot use a database above this size. You would need to upgrade the SQL Server Edition to use a database larger than 2GB. Other options include shrinking/removing some data (i.e. data which can be archived), or breaking the database up into multiple ones. What are you using the database for?

    Another option is to upgrade to SQL Server 2005 Express which allows a 4GB user database. Of course this requires extra work, planning, testing etc...

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

     

    Thanks


    Neil Moorthy Senior SQL Server DBA/Developer
    • Proposed as answer by moort Wednesday, November 03, 2010 5:35 AM
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 4:43 AM
    Wednesday, November 03, 2010 5:32 AM
  • You will be better of intalling SQL Server 2008R2 Express Edition which is limited to 10gb database size
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 4:43 AM
    Wednesday, November 03, 2010 6:41 AM
    Moderator