Tuesday, July 7, 2009

MOSS: SharePoint_Config LDF file grows drastically

Hey Folks...

In our MOSS server database, the SharePoint_Config_log.LDF file of database SharePoint_Config grows drastically. surprisingly it reaches more than 100 GB in months time... due to this there occurs lack of disk space. Currently I have scheduled to run a SQL query given by my friend to shrink the LDF file.

SQL Query:

BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
USE SharePoint_Config

GO
DBCC SHRINKFILE (SharePoint_Config_Log, EMPTYFILE)
GO

For time being this is the solution, If you are aware of any other permenant solution, please do let us know :)

Regards
Fauzi

2 comments:

AppsByAaron said...

Can't it just be deleted? I've got the same problem at work. I see two files very similar...
SharePoint_Config_de5196d6-f4fc-49ae-b8c1-bac0bb03c49a.mdf

And

SharePoint_Config_de5196d6-f4fc-49ae-b8c1-bac0bb03c49a_log.LDF

Mohammed Fauzi said...

@AppsByAaron: Seems its a know issue in MOSS, so i have scheduled to run this query once in two weeks.I believe we are not supposed to delete it because it might be used to store configuration details...