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:
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
@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...
Post a Comment