--循环数据库压缩日志文件(假设日志文件fileid=2)create table #db(id int identity(1,1),name varchar(80),dbsize int,mdfsize int,ldfsize int)insert into #db select a.name,SUM(b.size)*8/1024 as 'dbsize[MB]',  SUM(case when