存档

文章标签 ‘log’

sql server 2005收缩日志

2016年12月12日 没有评论

declare @db_name varchar(200)
declare @sql varchar(max)
declare my_cur cursor for
select name from sys.databases
where name not in (‘master’,’tempdb’,’model’,’msdb’)
open my_cur
fetch next from my_cur into @db_name
while @@fetch_status = 0
begin
set @sql = ‘use master;
backup log ‘+@db_name+’ with no_log;
dump transaction ‘+@db_name+’ with no_log;
use ‘+@db_name+’;
DBCC SHRINKFILE (2)

exec(@sql)
fetch next from my_cur into @db_name
end
close my_cur
deallocate my_cur

分类: 技术 标签: , , ,