This issue started with someone telling me that they couldn’t update a document in their team site – they got an error saying that they might be a problem with the library or the server might be busy.
I then tried uploading a file to the document library and got an error:
Unable to complete this operation. Please contact your administrator. at Microsoft.SharePoint.Library.SPRequestInternalClass.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage) at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl
I then tried updating a list item on the site and got an error:
Exception from HRESULT: 0x80040E14
This was happening not just on this site but on all the parent sites as well, right up to the root of the site collection. Basically it was impossible to do updates on the site collection. I found this page l and found plenty of errors in the SQL Server Database server. There was a low space warning on the drive related to transaction logs, and errors in the event log related to the SQL Transaction logs being full. Indeed the LDF files for the content databases were huge because they weren’t being cleared out properly during the backup. Shrinking down the log files solved the problem. The best way to do this is to is to use DBCC in Server Management Studio – remember to back up the log file first See http://support.microsoft.com/kb/907511. Note that you should not use AutoShrink with SharePoint databases. The moral is: always keep an wary eye on your SharePoint database server…