Showing posts with label SHRINKFILE. Show all posts
Showing posts with label SHRINKFILE. Show all posts

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