Hi, We have following dbs in simple recovery model in Sharepoint 2010 environment: Sharepoint_UsageApplication Sharepoint_Search_ Service_UserProfile_01 FAST_Content_Search_Service... FAST_Query_Search_Service... DocAve_ControlDB DocAve_ReportDB DocAve_AuditorDB I want to know what is impact if we do not change them to full recovery mode? Or what is best practice? Thanks

The model you choose is based on what sort of recovery options you want. Full provides you with the ability to perform point-in-time restores, where as Simple can only restore to the exact point that you made the backup. What is interesting however, is that by default these databases are created by SharePoint with the full recovery model. If they are currently set to simple, someone has manually changed them. In my experience I have most commonly seen this when the transaction logs start running wild and the recovery model is switched to easily truncate the logs. Jason Warren Infrastructure Specialist Habanero Consulting Group habaneroconsulting.com/blog