Thursday, March 11, 2010

Shrinking SharePoint Log files in SQL Server Database

Many times the log files generated in an application takes considerable amount of disk space.
To recover some storage area you need to run the following script inside concerned database's editor:

BACKUP LOG [MOSS_Content_11000_DE-DEV-MOSS]
WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (2,1, TRUNCATEONLY)GO