Error 1827: CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.
Wednesday, November 03, 2010 4:57 AM
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 5:32 AM
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...
Neil Moorthy Senior SQL Server DBA/Developer
Wednesday, November 03, 2010 6:41 AMAnswererYou 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