Use DB
Select NAME,size From sys.database_files
ALTER
DATABASE DB SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE DB SET
RECOVERY SIMPLE USE DB
DBCC SHRINKFILE(DB_log ,0,TRUNCATEONLY)
ALTER DATABASE DB SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE
DB SET RECOVERY FULL