Yesterday we had our July monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions – Business Continuity and Office 365 API.
Dinusha delivered a session on Office 365 API.
I delivered a session on implementing a business continuity for SharePoint and I covered topics such as monitoring SharePoint using Health Analyzer, Diagnosing logging, Usage and health data collection, implementing high availability using distributing servers and services using SharePoint WFEs, Application services servers, network load balancing, database mirroring, backup SharePoint and SQL Server databases and scheduling using Windows Task Scheduler.
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:
- Change the recovery model for the Database from Full to Simple
- 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.
ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE ('SharePoint_Config_Log')
Gathering requirements is always the challenging task in every SharePoint projects. Most of the projects fail and make customer unhappy for not capturing the right requirements.
Virtusa’s BA forum organized a session to discuss how best we can gather requirements for SharePoint projects and what are the best practices.
I was invited to deliver the session and I was very happy to educate them on how best we can capture requirements in SharePoint projects and what are the best practices to make customer happy at the end of the project.
Article – What’s New for SharePoint Development in Visual Studio 2012 – Part II – Streamlined SharePoint Project Templates
Learn about what’s new for SharePoint developers in Visual Studio 2012.
This is the 1st of series of interesting articles about SharePoint Development using Visual Studio 2012. Stay tuned for the rest of the articles.