sql server 2005收缩日志

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

发表评论

电子邮件地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据