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