declare @ssql nvarchar(4000) set @ssql= ' if ''?'' not in (''tempdb'',''master'',''model'',''msdb'') begin use [?] declare @tsql nvarchar(4000) set @tsql = '''' declare @iLogFile int declare LogFiles cursor for
--找出所有的Log文件，Log文件的status是0x40 select fileid from sysfiles where status & 0x40 = 0x40 open LogFiles fetch next from LogFiles into @iLogFile while @@fetch_status = 0 begin
--使用DBCC名字縮短Log文件 set @tsql = @tsql + ''DBCC SHRINKFILE(''+cast(@iLogFile as varchar(5))+'', 1) '' fetch next from LogFiles into @iLogFile end
--DBCC shrink只能釋放標(biāo)記為無效的Log區(qū)段，使用backup log可以完成這個標(biāo)記 set @tsql = @tsql + '' BACKUP LOG [?] WITH TRUNCATE_ONLY '' + @tsql --PRint @tsql exec(@tsql) close LogFiles DEALLOCATE LogFiles end' --依次遍歷所有的數(shù)據(jù)庫，用數(shù)據(jù)庫名字替換@ssql中的？，并執(zhí)行語句 exec sp_msforeachdb @ssql
