Friday, April 30, 2010

Truncating SharePoint DB log file

I could free few gig's of space after using the DBCC SHRINKFILE command , give it a try and you will realize the importance

USE DBName
GO
BACKUP LOG DBName WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (DBLogFile, 1)
GO
DBCC SHRINKFILE (DBLogFile, 1)
GO
exec sp_helpfile

No comments: