SharePoint 2010 - On site Experience

For two weeks now we(Myself and Microsoft team) has been on site in one of the bigest Oil and Gas Company in Nigeria. We started with kick off Meeting and now we are on documentation ranging from "Scope of Woke(SOW)", Planning and Physical Design documentation. Wao I got a template from Microsoft for the Design plan is quit diferent from what I use to know. Still working on it. I will keep you guys posted and hope to keep updating this post. Best of luck

Microsoft SQL Over growing Log Files

I got a call today from my client that the portal is not working. They post news on News Portal www.nanngronline.com. the portal is built using SharePoint Server 2007 and it has SQL 2005 as the back-end Database.

After about 15 mins trying to resolve the issue I came across a solution on the web. It was the log files that has over grown and has to be clear or shrink. I have to execute this command;

USE
GO
DBCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY
DBCC SHRINKFILE(, 1)
GO

for example;

USE SharePoint_Config
GO
DBCC SHRINKFILE(SharePoint_Config_log, 1)
BACKUP LOG sharePoint_Config WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SharePoint_Config_log, 1)
GO

I hope this will help somebody out in the future

ENJOY