12.10.2012

SharePoint Log File Shrinking

Here is a real gem for recovering space taken up by log file growth. It is of course recommended that you back up any files first.

USE SharePoint_Config
GO

ALTER DATABASE SharePoint_Config SET RECOVERY SIMPLE
DBCC SHRINKFILE(N'SharePoint_Config_log', 50)

ALTER DATABASE 
SharePoint_Config SET RECOVERY FULL
GO