SBS 2008: Huge sharepoint_config ldf file - not reducing in size!

Posted in Operating Systems, Windows, Tips on Tuesday, March 18, 2014 by

Recently had a client with an unused Sharepoint instance and very little free disk space left.

A review of the file system show that xxxxxxxx was 51GB!! … The server had 17GB free disk space. I knew it was a SQL log that hadn’t been truncated. But with little free disk space left and the fact that it was unused sharepoint - I was happy to discard the logs without backing them up.

I used the following commands to do so:

BACKUP LOG [database] WITH NO_LOG;
GO

ALTER DATABASE [database] SET RECOVERY SIMPLE;
GO 

use [database];
GO

DBCC SHRINKFILE([database_log],2);
GO

ALTER DATABASE [database] SET RECOVERY FULL;
GO

Success 67GB Free!!!