---测试SQL 2008数据库加密备份与还原[完备+差异备份]
/* 1.完整备份test数据库(加密码)*/
Use Test
BACKUP DATABASE [test] TO DISK = N'D:/test.bak' WITH NOFORMAT,
NOINIT, NAME = N'test-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10 ,
PASSWORD = '123456' --密码,很重要
/*----,compression (Express Edition 不支持 BACKUP DATABASE WITH COMPRESSION。)*/
GO
-------
--/*--对该完整备份的备份文件进行检查*/
--Use Test
--declare @backupSetId as int
--select @backupSetId = position from msdb..backupset
-- where database_name=N'test' and backup_set_id=(select max(backup_set_id) from
--msdb..backupset where database_name=N'test' )
--if @backupSetId is null
--begin
-- raiserror(N'验证失败。找不到数据库“test”的备份信息。', 16, 1)
--end
--RESTORE VERIFYONLY FROM DISK = N
/* 1.完整备份test数据库(加密码)*/
Use Test
BACKUP DATABASE [test] TO DISK = N'D:/test.bak' WITH NOFORMAT,
NOINIT, NAME = N'test-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10 ,
PASSWORD = '123456' --密码,很重要
/*----,compression (Express Edition 不支持 BACKUP DATABASE WITH COMPRESSION。)*/
GO
-------
--/*--对该完整备份的备份文件进行检查*/
--Use Test
--declare @backupSetId as int
--select @backupSetId = position from msdb..backupset
-- where database_name=N'test' and backup_set_id=(select max(backup_set_id) from
--msdb..backupset where database_name=N'test' )
--if @backupSetId is null
--begin
-- raiserror(N'验证失败。找不到数据库“test”的备份信息。', 16, 1)
--end
--RESTORE VERIFYONLY FROM DISK = N