花都社区个人博客空间开通啦,欢迎注册使用!
SQL数据库隔天备份
上一篇 /
下一篇 2007-07-02 10:47:18
/ 个人分类：网络编程及数据库
declare @tmp int
set @tmp = DATEDIFF(d,'2006-11-01',getdate())
if @tmp % 3 = 0
begin
BACKUP DATABASE [rollbook] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\rollbook.bak' WITH INIT , NOUNLOAD , NAME = N'rollbook 备份', NOSKIP , STATS = 10, NOFORMAT
end
else
begin
if @tmp % 3 = 1
begin
BACKUP DATABASE [rollbook] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\rollbook.bak' WITH INIT , NOUNLOAD , NAME = N'rollbook 备份', NOSKIP , STATS = 10, NOFORMAT
end
else if @tmp % 3 = 2
begin
BACKUP DATABASE [rollbook] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\rollbook.bak' WITH INIT , NOUNLOAD , NAME = N'rollbook 备份', NOSKIP , STATS = 10, NOFORMAT
end
end
导入论坛
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
