sqlserver自动备份:sqlserver 自动备份所有数据库的SQL来源: 发布时间:星期三, 2010年3月17日 浏览:52次 评论:0
复制代码 代码如下:
use master declare @DbName varchar(60) declare @BackSql varchar(1000) declare myCursor cursor for SELECT [name] FROM SYSDATABASES where [name] not in ('master','model','msdb','tempdb') order by [name] open myCursor fetch next from myCursor o @DbName while(@@FETCH_STATUS = 0) begin datename(weekday, getdate)='星期 3' --每周 3覆盖上周 3 begin select @BackSql='Backup DATABASE ['+@DbName+'] to disk=''E:\DbBackUp\'+@DbName+'星期 3.bak'' with format' end --每天覆盖上天 begin select @BackSql='Backup DATABASE ['+@DbName+'] to disk=''E:\DbBackUp\'+@DbName+'AutoBack.bak'' with format' end exec(@BackSql) fetch next from myCursor o @DbName end close myCursor DEALLOCATE myCursor 0
相关文章
读者评论发表评论 |