ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
GO
USE MASTER
GO
USE DatabaseName
GO
DBCC SHRINKFILE (DatabaseName_log, 1)
GO
ALTER DATABASE DatabaseName SET RECOVERY FULL
GO
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
GO
USE MASTER
GO
USE DatabaseName
GO
DBCC SHRINKFILE (DatabaseName_log, 1)
GO
ALTER DATABASE DatabaseName SET RECOVERY FULL
GO