Tuesday, August 07, 2007

Windows Sharepoint WSS Log error!

So aparently Hotfix "http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3B841216" from microsoft tells us that a upgrade from sharepoint 2 to sharepoint 3 will lead to this error.

but there is something else you also need to concider when getting these errors:

Exception from HRESULT: 0x80040E14
Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT)

Before even getting into Command line like microsoft recommend, have you tried checking disk space and whether the allocated space to your transcation logs in mssql have been cleared? if not, i would suggest doing it, as this is much easer than the fix microsoft recommends.

to do this, open up Mssql's admin console, goto the database, right click, shrink and choose files. choose the log file, ensure you have enough space to shrink it, and click ok.

so what happens if you dont have enough space? well first, check you have up-to-date backups. from there. if you do, go into the properties of the database and change the type of logs from "Full" to "basic". Now go back and shrink the log file again. this will reduce the file greatly. if you depend on mssql log files to backup your data as opposed to 3rd party products like backup exec or livestate system recovery, you should go back to the log file options and set it back to full.

while there is a lot of text explaining what to do, essentially all you are doing is turning the logs into a format that allows for removal of data, clearing up the space and setting it back.

Hope that helps, there wasnt anywhere enough info about it on the internet that wasnt bloated!

No comments: