Hi, We have MOSS 2007 SP1 databases on SQL Server 2005 EE x64 with SP3. We have scheduled the Transaction log backups to run every 1 hour and I noticed that the log backup for Sharepoint_config database is genarating 10 MB log every hr. i.e same 10 MB every hr. So I did not understand why this database is generating 10 MB of log every hour? It just the configuration database and NO transactions will happen on this database right? please clarify me thanks

Hi, As far as I know, 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). We do not recommend that you manually shrink the transaction log size or manually truncate the log by using the Truncate method. For more information about recovery model overview, please refer to the following article: Recovery Model Overview http://msdn.microsoft.com/en-us/library/ms189275.aspx For more information about back up logs (Windows SharePoint Services 3.0), please refer to the following article: Back up logs (Windows SharePoint Services 3.0) http://technet.microsoft.com/en-us/library/cc811601.aspx Hope this helps. Rock WangRock Wang MSFT

thank you. All our MOSS 2007 databases are in full recovery model and we are taking log backups every 1 hr. My question is why Sharepoint_config database is generating 10 MB log every hr, even though there is no activity happening? thanks