Transaction
log is full error – Steps to truncate the transaction log.
This is very
generic Error that every SharePoint administrator face in there experience.
Some times while trying to contribute to your site we will get ‘Unexpected
error’ or Result error with some error code. If we see more into the event
viewer log, we will find that a SQL Server error has occurred which states that
the transaction log is full. In this article I am providing the steps that How
to truncate the Transaction log.
Solution: Follow the below steps to truncate
the Logs.
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
No comments:
Post a Comment
Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula