COMException: 0x80131904 while deleting sharepoint 2010 files

I was getting below error while trying to delete files in a sharepoint 2010 site collection.


StackTrace: ' at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)
at Microsoft.SharePoint.Library.SPRequest.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId) at Microsoft.SharePoint.SPListItem.DeleteCore(DeleteOp deleteOp) at Microsoft.SharePoint.SPListItem.Delete() at VFS.PMS.ApplicationPages.CommonMaster.DeleteCompetenciesDraft(Int32 appraisalPhaseId, String currentUser, String listName) at VFS.PMS.ApplicationPages.Layouts.H2initial.SelfEve.SaveCompetenciesDraft(Int32 appraisalID, Int32 appraisalPhaseId, String listName) at VFS.PMS.ApplicationPages.Layouts.H2initial.SelfEve.b_0() at Microsoft.SharePoint.SPSecurity.<>c_DisplayClass4.b__2() at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at VFS.PMS.ApplicationPages.Layouts.H2initial.SelfEve.btnSave_Click(Object sender, EventArgs e)' Source: 'Microsoft.SharePoint' TargetSite: 'Void HandleComException(System.Runtime.InteropServices.COMException)' ------------------------------------------------------------ Inner exception:
------------------------------------------------------------ ExceptionType: 'COMException' ExceptionMessage: '0x80131904'
StackTrace: ' at Microsoft.SharePoint.Library.SPRequestInternalClass.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId) at Microsoft.SharePoint.Library.SPRequest.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId)' Source: '' TargetSite: 'Void DeleteItem(System.String, System.String, Int32, UInt32, System.Guid ByRef)' 8f922003-389d-4edf-b75f-7e69c5818a7a


It was resolved after I added myself in farm administrators group and then gave dbo permissions on the content database for the site collection and then shrinked database files using below post

http://support.powerdnn.com/kb/a447/how-to-shrink-your-mssql-database-log-file-truncate.aspx

More reference can be found in the comments in the post below:

http://stackoverflow.com/questions/10723746/sharepoint-2010-error-0x80131904-after-uploading-large-amount-of-files