Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

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