Some of my SharePoint databases have really big log files. The databases are configured to use the Full recovery model.I was wondering if changing the recovery model to simple would be an acceptable configuration in SharePoint.

You can always use the simple recovery model, but you will not be able to restore to a point in time of the failure, only to the time of the last backup.. Simple is great for DEV... (Most of the Time)Why not just back up the log files, run shrink db, then another backup will shrink the trn logs BACKUP LOG [WSS_Content_MySite] TO DISK = N'G:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\WSS_Content_MySite_backup_2010_02_12_085135_5665176.trn' WITH NOFORMAT, NOINIT, NAME = N'WSS_Content_MySite_backup_2010_02_12_085135_5645176', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 BACKUP DATABASE [WSS_Content_MySite] TO DISK = N'G:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\WSS_Content_MySite_backup_2010_02_12_085653_3125176.bak' WITH NOFORMAT, NOINIT, NAME = N'WSS_Content_MySite_backup_2010_02_12_085653_3075176', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 USE [WSS_Content_MySite] GO DBCC SHRINKDATABASE(N'WSS_Content_MySite', 10, TRUNCATEONLY) BACKUP LOG [WSS_Content_MySite] TO DISK = N'G:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\WSS_Content_MySite_backup_2010_02_12_085135_5665177.trn' WITH NOFORMAT, NOINIT, NAME = N'WSS_Content_MySite_backup_2010_02_12_085135_5645176', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 BACKUP DATABASE [WSS_Content_MySite] TO DISK = N'G:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\WSS_Content_MySite_backup_2010_02_12_085653_3125177.bak' WITH NOFORMAT, NOINIT, NAME = N'WSS_Content_MySite_backup_2010_02_12_085653_3075176', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10<br/><br/><br/><br/><br/><br/> Cheers,-IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.

How big are your ldfs vs mdfs?John SharePoint911: SharePoint Consulting Blog: http://www.rossonmoss.com Twitter: JohnRossJr MOSS Explained: An Information Workers Deep Dive into Microsoft Office SharePoint Server 2007

Hi,As Ivan mentioned, you wont be able to get to the till-point restoration done. I can suggest you one more way to work on this if the db is a production one -1> Keep the database in FULL mode.2> I would suggest to keep a full backup and differential backup job running on weekdays and in the weekend go to point 3.3> Make it a point to backup the database in simple mode every weekend. So that once this is done, the log file truncates and you shall get more free space.Hope this helps...