Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14"

and i checked event viewer.here also some error showing "

  1. CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database

  2. Database full error on SQL Server instance 'mps\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below. Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. i have backup some database and deleted unwanted database.now the database size is 2GB only (D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

social.technet.microsoft.com/Forums/en/sharepointadmin/thread/9b3259cc-2bf6-4127-bd57-df3b866f6d8f

i have shrink the database also using below the URL

msdn.microsoft.com/en-us/library/ms190757.aspx

But the 4GB error is again and again coming.

How to resolve this?Thanks in advance,Velmurugan

share|improve this question

migrated from stackoverflow.com Oct 25 '11 at 11:00

This question came from our site for professional and enthusiast programmers.

2 Answers 2

If that is not an option (upgrading sql) then you can create a new content DB.. migrate some sites into the new DB to free up space in the old Content DB... Set the old content DB to "no new sites" and then you'll start filling up the new content db.

share|improve this answer

It sounds like you are using SQL Server Express, which has a 4G size limit. You'll need to upgrade you copy of SQL Server.

http://www.dotnetspider.com/tutorials/sqlserver-tutorial-158.aspx
share|improve this answer
2  
Actually just upgrade to SQL Server Express 2008 R2 - the limit was raised to 10gb there. –  TomTom Jul 4 '10 at 13:47
1  
Express could indeed be tough to use with Sharepoint because it embeds the documents in the database and grows quite big with many documents. –  Turnkey Jul 4 '10 at 13:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.