34,590
社区成员
发帖
与我相关
我的任务
分享
USE [test]
GO
/****** 对象: StoredProcedure [dbo].[BackupFullDB] 脚本日期: 05/09/2012 04:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BackupFullDB]
@DBName VARCHAR(100),
@ym VARCHAR(6),
@ymd VARCHAR(8),
@BackupFile VARCHAR(100),
@BackName VARCHAR(100),
@tmp VARCHAR(100),
@backupSetId INT
AS
EXECUTE ('BACKUP DATABASE' + ' ' +
'[' +
@DBName +
']' +
'TO DISK =' +
@BackupFile + ' ' +
'WITH' + ' ' +
'NOFORMAT' +
',NOINIT' +
',NAME =' +
@BackName +
',SKIP' +
',NOREWIND' +
',NOUNLOAD' +
',STATS =' +
@backupSetId +
',CHECKSUM')
USE test
DECLARE @DBName VARCHAR(100)
DECLARE @ym VARCHAR(100)
DECLARE @tmp VARCHAR(100)
DECLARE @BackupFile VARCHAR(100)
DECLARE @BackName VARCHAR(100)
DECLARE @backupSetId INT
EXECUTE dbo.BackupFullDB
@DBName = 'Beijixiong_Data',
@ym = Convert(char(6),getdate() ,112),
@tmp = '''验证失败。找不到数据库' + @DBName + '的备份信息。''',
@BackupFile = N'''E:\FULL\' + @DBName + '_' + 'full' + '_' + @ym + '.bak''',
@BackName = '''' + @DBName + '_' + 'full' + '_' + @ym + '''',
@backupSetId = 10
USE [test]
GO
/****** 对象: StoredProcedure [dbo].[BackupFullDB] 脚本日期: 05/09/2012 04:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BackupFullDB]
@DBName VARCHAR(100),
@ym VARCHAR(6),
@ymd VARCHAR(8),
@BackupFile VARCHAR(100),
@BackName VARCHAR(100),
@tmp VARCHAR(100),
@backupSetId INT
AS
EXECUTE ('BACKUP DATABASE' + ' ' +
'[' +
@DBName +
']' +
'TO DISK =' +
@BackupFile + ' ' +
'WITH' + ' ' +
'NOFORMAT' +
',NOINIT' +
',NAME =' +
@BackName +
',SKIP' +
',NOREWIND' +
',NOUNLOAD' +
',STATS =' +
CAST(@backupSetId AS VARCHAR(10)) +
',CHECKSUM')
create procedure [dbo].[BackupFullDB]
@DBName VARCHAR(100),
@ym VARCHAR(6),
@ymd VARCHAR(8),
@BackupFile VARCHAR(100),
@BackName VARCHAR(100),
@tmp VARCHAR(100),
@backupSetId INT
as
begin
declare @sql varchar(6000)
select @sql='BACKUP DATABASE' + ' ' +
'[' +
@DBName +
']' +
'TO DISK =' +
@BackupFile + ' ' +
'WITH' + ' ' +
'NOFORMAT' +
',NOINIT' +
',NAME =' +
@BackName +
',SKIP' +
',NOREWIND' +
',NOUNLOAD' +
',STATS =' +
cast(@backupSetId as varchar(6)) +
',CHECKSUM'
exec(@sql)
end
USE test
DECLARE @DBName VARCHAR(100),@DBName2 VARCHAR(100)= 'Beijixiong_Data'
DECLARE @ym VARCHAR(100),@ym2 VARCHAR(100)=Convert(char(6),getdate() ,112)
DECLARE @tmp VARCHAR(100),@tmp2 VARCHAR(100)= '验证失败。找不到数据库' + @DBName2 + '的备份信息。'
DECLARE @BackupFile VARCHAR(100),@BackupFile2 VARCHAR(100)= N'''E:\full\' + @DBName2 + '_' + 'full' + '_' + @ym2 + '.bak'''
DECLARE @BackName VARCHAR(100),@BackName2 VARCHAR(100)= '''' + @DBName2 + '_' + 'full' + '_' + @ym2 + ''''
DECLARE @backupSetId int
EXECUTE dbo.BackupFullDB
@DBName = @DBName2,
@ym = @ym2,
@ymd = '',
@tmp = @tmp2,
@BackupFile = @BackupFile2,
@BackName = @BackName2 ,
@backupSetId = 10