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.
- Open SQL Server Management Studio and locate your site’s content db(You can find it from the central admin site).
- Select your 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.
- That’s it. Transaction Log is truncated 🙂