SharePoint config databases transaction log generation

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  February 25, 2010 at 12:11 pm

  #386398

  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 generating 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 for share point and NO transactions will happen on this database right?

  please clarify me

  thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 25, 2010 at 5:41 pm

  #1125308

  Not sure, but please start with these articles and research and determine if they applicable to your situation:

  SQL Server SharePoint_Config database Transaction log backup plan failed

  http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/3b1ac6d7-bd7a-46ee-8c7a-1d1b0e18bd56

  SharePoint Database Growth Rates

  http://vspug.com/llowevad/2007/06/25/sharepoint-database-growth-rates/

  Massive SharePoint config database log file

  http://blog.mgallen.com/?p=328

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/