use master
alter database DBName set recovery simple
USE DBName;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE(DBName_LOG, 1);
GO
alter database DBName set recovery simple
USE DBName;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE(DBName_LOG, 1);
GO