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...

Read more »

Movie Review : Bodyguard

This is the third time for Siddique. Yes, believe it or not, this is the third time that the writer-director has chosen to film this yucky yarn in the span of a year and a half – first in Malayalam, then in Tamil and now in Hindi, effecting minor changes in each follow-up without achieving any perceptible improvement. He and the producer of this film probably had no option. Who in the right mind would want to direct this damp squib of a screenplay thrice even if he has Salman Dabangg Khan’s tried-and-tested biceps and pectorals to hang its hollow premise on? The thread that Bodyguard hangs from is hopelessly slender and perpetually on the brink of snapping. If it doesn’t end up in a complete heap, credit in some measure is certainly...

Read more »