Cacher is the code snippet organizer for pro developers

USE @dbName
GO
ALTER DATABASE @dbName SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE('@logFileName', 1)
ALTER DATABASE @dbName SET RECOVERY FULL WITH NO_WAIT
GO