USE DatabaseName GO DBCC SHRINKFILE( , 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE( , 1) GO In Case of SharePoint server .this problem often observed .to resolve the same ..following query works well for me USE SharePoint_Config GO DBCC SHRINKFILE(SharePoint_Config_log, 1) BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY DBCC SHRINKFILE(SharePoint_Config_log, 1) GO