Problem: In our MOSS 2007 server log file for SharePoint_Config database is huge, almost 14 GB size. We need to shrink the file and recover hard disk space.
Resolution: Execute the following SQL Sentence for the database above
USE SharePoint_Config
GO
DBCC SHRINKFILE(SharePoint_Config_log, 1)
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SharePoint_Config_log, 1)
No comments:
Post a Comment