USE [master] GO /****** Object: StoredProcedure [dbo].[fullbackup] Script Date: 07/03/2013 07:29:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[fullbackup] ( @backupPath varchar(500), @databasename varchar(100), @backuptype varchar(100) ) as DECLARE @FullPath varchar(1000) set @FullPath = @backuppath+@databasename+'_'+@backuptype+'_'+replace(replace(replace(convert(varchar,getdate(),20),'-',''),' ',''),':','')+ '.bak' backup database @databasename to disk=@FullPath WITH buffercount = 20, maxtransfersize = 2097152 ,COMPRESSION, RETAINDAYS=15,NOFORMAT,NOINIT, NAME=N'完整备份',SKIP,NOREWIND, NOUNLOAD,STATS=10 return go USE [master] GO /****** Object: StoredProcedure [dbo].[diffBackup] Script Date: 07/03/2013 07:30:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[diffBackup] ( @backupPath varchar(500), @databasename varchar(100), @backuptype varchar(100) ) as DECLARE @FullPath varchar(1000) set @FullPath = @backuppath+@databasename+'_'+@backuptype+'_'+replace(replace(replace(convert(varchar,getdate(),20),'-',''),' ',''),':','')+ '.diff' backup database @databasename to disk=@FullPath WITH buffercount = 30, maxtransfersize = 2097152 , COMPRESSION, DIFFERENTIAL,RETAINDAYS=8,NOFORMAT,NOINIT, NAME=N'差异备份',SKIP,NOREWIND, NOUNLOAD,STATS=10 return go USE [master] GO /****** Object: StoredProcedure [dbo].[logBackup] Script Date: 07/03/2013 07:30:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[logBackup] ( @backupPath varchar(500), @databasename varchar(100), @backuptype varchar(100) ) as DECLARE @FullPath varchar(1000) set @FullPath = @backuppath+@databasename+'_'+@backuptype+'_'+replace(replace(replace(convert(varchar,getdate(),20),'-',''),' ',''),':','')+ '.trn' backup log @databasename to disk=@FullPath WITH RETAINDAYS=3,NOFORMAT,NOINIT, NAME=N'日志备份',SKIP,NOREWIND, NOUNLOAD,STATS=10 return go use master go exec master.dbo.fullbackup 'I:\backup\test\','test','full' go use master go exec master.dbo.diffbackup 'I:\backup\test\','test','diff' go use master go exec master.dbo.logbackup 'I:\backup\test\','test','log' go
sqlserver 2008 R2备份脚本
原创文章标签 备份脚本 sqlserver 2008 R2 文章分类 运维
©著作权归作者所有:来自51CTO博客作者ocpyang的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:自动统计信息收集情况
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
MySQL 8自动备份脚本密码安全警告
作者:田逸(formyz)目标需求接到一个任务,需要在凌晨四点对一个数据库进行备
mysql v8 MySQL