Transaction log is full error – Steps to truncate the transaction log.

Some times while trying to contribute to your site you will get ‘Unexpected error’ or HResult error with some error code. If you investigate further by looking into the event viewer log, you will find that a SQL Server error has occured which states that the transaction log is full. Follow the below steps to truncate the transaction log.

  1. Open SQL Server Management Studio and locate your site’s content db(You can find it from the central admin site).
  2. Select your  db and right click to open the backup task.
  3. Select the Transaction Log to backup, go to options and select the radio button Truncate Log.
  4. Start the backup.
  5. That’s it. Transaction Log is truncated 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a website or blog at

Up ↑

%d bloggers like this: