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.

Answer 1

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

Answer 2

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/