--log dosyasını bul     
 SELECT name FROM sys.master_files WHERE type_desc = 'LOG' and physical_name like '%Jam%'




        ALTER DATABASE DevJamieS
        SET RECOVERY SIMPLE
        GO
        DBCC SHRINKFILE (DevJamieS_log, 1)
        GO
        ALTER DATABASE DevJamieS
        SET RECOVERY FULL

------------

USE LKSDB;
GO
ALTER DATABASE LKSDB
SET RECOVERY SIMPLE;
GO

--datadakı log dosyasını shrınk yap

ALTER DATABASE LKSDB
SET RECOVERY FULL;
GO

EXEC sp_msforeachdb ' Declare @logname varchar(500) = '''';

IF ''?'' not in (''tempdb'',''master'',''msdb'',''model'',''Reportserver'',''ReportserverTempDB'') 
begin 
 
	set @logname = (Select name From [?].Sys.database_files where  type=1) 

	EXEC(''Use [?];
	ALTER DATABASE ?
	SET RECOVERY SIMPLE; 
		DBCC SHRINKFILE (['' + @logname + ''] ,1)
		 
		ALTER DATABASE ?
		SET RECOVERY FULL
		'')  
end 
'