Monday, January 11, 2010

SQL Server - SharePoint_Config_Log.LDF in worst ever data to log ratio

image

Apparently this is quite a common problem with the SharePoint config database, but it still amused me.  A 10 megabyte database generating a 38 GIGABYTE log?!

I'd say the disk space issues on that server have just been solved.

I could just set that database to Simple recovery model, but I think I will be good and put a daily transaction log backup on it. 

I might truncate it first.

BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY

Then.

USE SharePoint_Config
GO
DBCC SHRINKFILE('SharePoint_Config_log', 2)
GO

33gb disk space freed up.  Now back it up!

No comments:

Post a Comment