Saturday, December 13, 2008
Trucated Log file for SharePoint 2007 Configuration database

Sometime, it looks impossible to shrink the Trucated Log file for SharePoint 2007 Configuration database. Following code always shrinks the Trucated Log File to minimum size possible.

USE SharePoint_Config

GO

DBCC SHRINKFILE(SharePoint_Config_log, 1)

BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY

DBCC SHRINKFILE(SharePoint_Config_log, 1)

Saturday, December 13, 2008 2:42:36 PM (Pacific Standard Time, UTC-08:00)  #    Comments [0]

© Copyright 2012 Aivea Corporation
Theme design by Bryan Bell

newtelligence dasBlog 2.0.7226.0
Feed your aggregator (RSS 2.0)  Send mail to the author(s) | Page rendered at Saturday, February 04, 2012 10:18:07 AM (Pacific Standard Time, UTC-08:00)

Pick a theme: