USE [master]
ALTER DATABASE DB_NAME SET RECOVERY SIMPLE WITH NO_WAIT

ALTER DATABASE DB_NAME SET RECOVERY SIMPLE

USE DB_NAME

DBCC SHRINKFILE (N’DB_LOG_FILE_NAME’ , 11, TRUNCATEONLY)

ALTER DATABASE DB_NAME SET RECOVERY FULL