Joy's Blog Learning never stops…!!!

2Jul/150

Article – Tips and Tricks – reducing the SharePoint Config Log file

Posted by Joy

Today we came across with a situation where we keep getting a runtime error when we try to perform our normal day-today operations in our SharePoint 2013 based solution. It started throwing a runtime error with a error code - HRESULT: 0x80131904 and it failed to save data into the SharePoint database.

The reason was the SharePoint Configuration database LOG file has grown to 91 GB and there was not enough free space in the physical disk. Because of this, SharePoint was unable to commit database changes and there was a huge performance impact. The solution we found was:

  1. Change the recovery model for the Database from Full to Simple
  2. Shrink the database

I executed the following SQL command and it brought the database log file from 91GB to 1 MB which solved my issues.

USE [master]
Go

ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
Go

USE [SharePoint_Config]
Go

DBCC SHRINKFILE ('SharePoint_Config_Log')
Go

12Mar/150

Sri Lanka SharePoint Forum – March, 2015

Posted by Joy

Yesterday we had our March monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions lined up – Search and Branding.

Malin delivered a session around Branding and Design Manager capabilities. I delivered a session around SharePoint Search which covered configuring multiple content sources, result sources, query rules, etc…

29Oct/130

Article – Tips and Tricks – SharePoint 2013 support for Windows Server 2012 R2

Posted by Joy

Learn the SharePoint 2013 support for Windows Server 2012 R2.

http://www.sharepoint24x7.com/2013/10/29/tips-n-tricks-sharepoint-2013-support-for-windows-server-2012-r2/

17Jul/130

Article – Authentication Improvements in SharePoint 2013

Posted by Joy

Learn authentication improvements in SharePoint 2013.

http://www.sharepoint24x7.com/2013/07/17/article-authentication-improvements-in-sharepoint-2013/

4May/130

Article – SharePoint 2013 New Features – Shredded Storage

Posted by Joy

Learn new Shredded Storage feature which is available in SharePoint 2013.

http://www.sharepoint24x7.com/2013/05/04/article-sharepoint-2013-new-features-shredded-storage/

3Apr/130

Article – SharePoint 2013 New Features – Minimal Download Strategy (MDS)

Posted by Joy

Learn about new Minimal Download Strategy (MDS) in SharePoint 2013.

http://www.sharepoint24x7.com/2013/04/03/article-sharepoint-2013-new-features-minimal-download-strategy-mds/

19Mar/130

Article – What’s New for SharePoint Development in Visual Studio 2012 – Part II – Streamlined SharePoint Project Templates

Posted by Joy

Learn about what’s new for SharePoint developers in Visual Studio 2012.

http://www.sharepoint24x7.com/2013/03/19/article-whats-new-for-sharepoint-development-in-visual-studio-2012-part-ii-streamlined-sharepoint-project-templates/

18Mar/130

Article – How to enable SharePoint 2013 Development Project Templates in Visual Studio 2012

Posted by Joy

Learn how to enable SharePoint 2013 project templates in Visual Studio 2012.

http://www.sharepoint24x7.com/2013/03/18/articlehow-to-enable-sharepoint-2013-development-project-templates-in-visual-studio-2012/