Recovery Model - Sharepoint dbs
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
July 19th, 2012 1:49pm

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
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2012 9:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics