|
脚本语句按照截图填写 
?
DECLARE @dbname NVARCHAR(20)
SET @dbname=N'aa'--你需要备份的库名
--定义备份时间，精确到秒
DECLARE @date NVARCHAR(64)
SELECT? @date = SUBSTRING(CONVERT(VARCHAR(20),GETDATE(),121),1,4) + '_'
??????? + SUBSTRING(CONVERT(VARCHAR(20),6,2) + '_'
??????? + SUBSTRING(CONVERT(VARCHAR(20),9,2) + '_'
??????? + CONVERT(CHAR(2),DATEPART(hh,GETDATE()))
??????? + CONVERT(CHAR(2),DATEPART(mi,DATEPART(ss,GETDATE()))
--定义要备份的数据库名
DECLARE @db NVARCHAR(20)
SET @db = '' + @dbname + ''
--定义备份文件的全名
DECLARE @bakname NVARCHAR(128)
SELECT? @bakname = @db + '_' + @date
--定义备份存放路径
DECLARE @disk NVARCHAR(256)
SELECT? @disk = N'e:databasebackup' + @bakname + '.bak'? --备份路径名
--定义备份描述
DECLARE @name NVARCHAR(128)
SELECT? @name = @db + '-完整 数据库 备份'
--定义错误信息
DECLARE @error NVARCHAR(128)
SELECT? @error = '验证失败。找不到数据库“' + @db + '”的备份信息。'
BACKUP DATABASE @db TO? DISK = @disk WITH? COPY_ONLY,NOFORMAT,NOINIT,?
NAME =@name,SKIP,NOREWIND,NOUNLOAD,? STATS = 10,CHECKSUM ; DECLARE @backupSetId AS INT SELECT? @backupSetId = position FROM??? msdb..backupset WHERE?? database_name = @db ??????? AND backup_set_id = ( SELECT??? MAX(backup_set_id) ????????????????????????????? FROM????? msdb..backupset ????????????????????????????? WHERE???? database_name = @db ??????????????????????????? ) IF @backupSetId IS NULL ??? BEGIN ??????? RAISERROR(@error,16,1) ??? END RESTORE VERIFYONLY FROM? DISK = @disk WITH? FILE = @backupSetId,? NOUNLOAD,? NOREWIND GO
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
