We have seen some mention made of the SharePoint configuration databases getting quite large.
To date, we did not see any simple way to reduce the size of those databases.
Microsoft Support has released a Knowledgebase article with a simple SQL based script to trim the database size:
- Microsoft KB 2000544: SBS 2008 BPA Reports that The Windows SharePoint Services configuration databases log file is getting large (currently over 1gb in size)
- SBS 2008 Best Practices Analyzer (BPA) (download page)
Make sure to run a full backup just before running the script. This will enable a quick recovery of the server if things go sideways.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book