Saturday, July 5, 2008

Truncate SQL Server Transaction Log

Many time you will face an issue while trying to add new user, column,list etc to a sharepoint site and the error displayed would be either 'Unexpected error' or some HResult error with a 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. If this is the case then follow the given below steps to truncate the transaction log.

  1. Open SQL Server Management Studio and locate the site content db.
  2. Select the 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. Done.Transaction Log is truncated.

No comments:

Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to