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


Comments can be formatted using a simple wiki syntax.

这篇文章的评论 feed

Powered by Dotclear | Original theme by N.Design Studio - Adapted by Pixials and Pierre Van Glabeke

文章 feed 评论 feed