The SharePoint Config log DB can grow quite large!

The following way can help you shrink the config databases. But do only use these in test or development enviroments!

SharePoint 2010 on SQL 2008 R2

  1. Right click on you DB -> Properties
  2. Select Options
  3. Change the Recovery Model to SIMPLE and Click Ok
Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK
 
Note : Simple recovery model is not suggested for Production Systems
 

SharePoint 2007 on SQL 2005

Make two new Queries

BACKUP LOG [Sharepoint_Config] WITH TRUNCATE_ONLY
USE [SharePoint_Config]
GO
 

DBCC SHRINKFILE (N’SharePoint_Config_log’ , 50)
GO



Tags: , , | Categories: Database | SharePoint Development