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

Posted: June 28, 2011 in Errors, SQL

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 🙂
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s