- Open SQL Server Management Studio and locate the site content db.
- Select the db and right click to open the backup task.
- Select the Transaction Log to backup, go to options and select the radio button 'Truncate Log'.
- Start the backup.
- Done.Transaction Log is truncated.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment