MSSQL收缩所有数据库，让*.ldf日志文件都变成1M

declare cur cursor for select name from Master..SysDatabases where name<>'master' and name<>'model' and name<>'msdb' and name<>'Northwind' and name<>'pubs'
declare @tb sysname 

open cur 
fetch next from cur into @tb 
while @@fetch_status=0 
begin 
  exec ('dump transaction ['+@tb+'] with no_log') 
  exec ('backup log ['+@tb+'] with no_log') 
  exec ('dbcc shrinkdatabase(['+@tb+'])') 
  fetch next from cur into @tb 
end 
close cur 
deallocate cur