Hi all, since 1 year we have a sharepoint installation hosting our intranet site, backed up every 2 days through stsadm full-farm backup. The WSS_xxx and Sharepoint_Config database are growing very fast, and i found on knowledge base how to backup, shrink and so reduce the size of them. Both of them have full recovery mode. My doubt is about the relation with stsadm backup command...should it be correct to put the recovery mode of the 2 db to simple mode, due to the regular stsadm backup? I found a lot of info about the difference between the 2 models, but i cannot understand how this work together with stsadm command. Thank you for explaining me the best way. Andrea

[My Opinion] I think putting a SQL server in to SIMPLE Recovery Mode is just fine. Transaction Log files - in my opinion - are basically useless. Since you are getting a SharePoint backup you should be fine with the data. Also, I would recommend making a weekly copy of the Content Database. I hope this helps and answers your question-Jeff DeVerter, MCSERackspaceblog:http://www.social-point.comtwitter: http://www.twitter.com/jdeverter

Hi, If the database recovery mode is simple, transaction logs get automatically truncated when you run stsadm –o backup. For full recovery mode, the transaction logs only get truncated when a full backup of the database is performed. OOTB Recovery model settings for SharePoint databases are as follows: · Content Database - Full Recovery Model · Configuration Database - Full Recovery Model · SSP Database - Simple Recovery Model The recommended way to truncate the transaction log if you are using a full recovery model is to back up the log. SQL Server 2005 automatically truncates the inactive parts of the transaction log when you back up the log. It is also recommended that you pre-grow the transaction log to avoid auto-growing the log. For more information about growing the transaction log, see Managing the Size of the Transaction Log File (http://go.microsoft.com/fwlink/?LinkId=124882). For more information about using a full recovery model, see Backup Under the Full Recovery Model (http://go.microsoft.com/fwlink/?LinkId=127985). For more information about using a simple recovery model, see Backup Under the Simple Recovery Model (http://go.microsoft.com/fwlink/?LinkId=127987). Hope this helps. Rock WangRock Wang MSFT

Ok, perfect... so running stsadm -backup command of the full farm, is truncating the log only if recovery mode is set to simple. Thank you all for the answers! Andrea