SQL备份文件加密与还原[整理]

--用以下语句备份数据库
BACKUP DATABASE [demo] TO  DISK = N'C:/demo.bak' WITH NOFORMAT,
 NOINIT,  NAME = N'demo-完整 数据库 备份',
 SKIP, NOREWIND, NOUNLOAD,  STATS = 10 ,
 PASSWORD = '123456'    --密码，可要记录哟
GO
--对备份文件进行检查
declare @backupSetId as int
select @backupSetId = position from msdb..backupset
 where database_name=N'demo' and backup_set_id=(select max(backup_set_id) from

msdb..backupset where database_name=N'demo' )
if @backupSetId is null
begin
 raiserror(N'验证失败。找不到数据库“demo”的备份信息。', 16, 1)
end
RESTORE VERIFYONLY FROM  DISK = N'C:/demo.bak' WITH  FILE = @backupSetId, 
 NOUNLOAD,  NOREWIND ,
 PASSWORD = '123456'   --检查时也需要输入密码
GO

--用加密的备份文件还原数据库
RESTORE DATABASE [de] FROM  DISK = N'C:/demo.bak' WITH  FILE = 1, 
 MOVE N'Demo' TO N'D:/database/De.mdf', 
 MOVE N'Demo_log' TO N'D:/database/De_log.ldf', 
 NOUNLOAD,  STATS = 10,
 PASSWORD = '123456'   --注意输入密码
GO