Symptoms
We are currently running out of space on a development machine. The K2SmartBroker_log.LDF is 3.5GB.... Could you please provide us a SQL script that can clean this file up for us so we can have some space back to continue developing.
Diagnoses
The LDF file was continuing to grow to an impractical size and needed to be truncated.
Resolution
The customer discovered that the following SQL code brought the file back down to a manageable size:
USE [K2SmartBroker]
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE K2SmartBroker
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 50 MB.
DBCC SHRINKFILE (K2SmartBroker_Log, 50)
GO