1

Topic: Truncating log file

USE NBNData 
GO 
-- Truncate the log by changing the database recovery model to SIMPLE. 
ALTER DATABASE NBNData
SET RECOVERY SIMPLE; 
GO 
-- Shrink the truncated log file to 1 MB. 
DBCC SHRINKFILE (NBNData_Data, 1); 
GO

Mike Weideli
Littlefield Consultancy - IT Consultants