The transaction log for database ‘WSS_Content’ is full.

Problem

We have WSS 3.0 running on Windows Server 2008 R2 internal database. One of our users recently received an error when trying to give another user permissions. The error message was ‘Exception from HRESULT: 0x80040E14 which didn’t mean anything.

Checking the ULS logs, the following error message is displayed.

Unexpected query execution failure, error code 9002. Additional error information from SQL Server is included below. “The transaction log for database ‘WSS_Content’ is full.

Solution

Shrink the database log file:

  1. Run SQL Management Studio and login to your SharePoint instance.
  2. Click on ‘New Query’
  3. Type in the following commands:
  4. USE [database name];
    BACKUP LOG [database name] WITH TRUNCATE_ONLY;
    DBCC
    SHRINKFILE ([log file name], 1);
  5. Replace [database name] and [log file name] with your log file.
  6. This will truncate your log file to 1mb.
Note, this command does not work on SQL 2008 R2. [22/3/2012]

Do an IISRESET and all should be good.

 

Tags:

No comments yet.

Leave a Reply

%d bloggers like this: