Truncate SQL Server Log

To shrink the DataBase log as small as possible, use this query:

declare @DB varchar(max)set @DB = ''use masterdeclare @code as nvarchar(2000)select @code = 'USE[' + LTRIM(RTRIM(sdb.[name])) + '] DBCC SHRINKFILE(' + LTRIM(RTRIM(saf.[name])) + ',1, TRUNCATEONLY )'from sysaltfiles as saf inner join sysdatabases as sdb on saf.dbid = sdb.dbidwhere saf.[filename] like '%.ldf%' and sdb.[name] = @DBexec sp_executesql @code