Thursday, March 18, 2010

My 2008 Logs are tooo big

Maintenance plans not working? Running out of disk space?
Clean out those log files.

USE SharePoint_Config
GO
ALTER DATABASE SharePoint_Config
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (SharePoint_Config_Log, truncateonly)
GO
ALTER DATABASE SharePoint_Config
SET RECOVERY FULL;
GO

No comments:

Post a Comment