declare @Str varchar(800) set @Str = 'ALTER DATABASE ? SET RECOVERY SIMPLE' + CHAR(13) + 'DBCC SHRINKFILE (N''?_log'',0,TRUNCATEONLY)' execute sp_msForEachdb @Str