数据库加密备份，还原

最新推荐文章于 2020-08-04 11:30:11 发布

dzx023

最新推荐文章于 2020-08-04 11:30:11 发布

阅读量367

点赞数

分类专栏： SQL 文章标签：数据库加密 database disk file null

本文链接：https://blog.csdn.net/dzx023/article/details/4455837

版权

SQL 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

--用以下语句备份数据库
BACKUP DATABASE [exam] TO DISK = N'd:/exam.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'exam' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'exam' )
if @backupSetId is null
begin
raiserror(N'验证失败。找不到数据库“demo”的备份信息。', 16, 1)
end
RESTORE VERIFYONLY FROM DISK = N'd:/exam.bak' WITH FILE = @backupSetId,
NOUNLOAD, NOREWIND ,
PASSWORD = '123456' --检查时也需要输入密码
GO

--用加密的备份文件还原数据库
RESTORE DATABASE [exam] FROM DISK = N'd:/exam.bak' WITH FILE = 1,
MOVE N'exam_Data' TO N'C:/Program Files/Microsoft SQL Server/MSSQL/Data/exam_Data.MDF',
MOVE N'exam_log' TO N'C:/Program Files/Microsoft SQL Server/MSSQL/Data/exam_Log.LDF',
NOUNLOAD, STATS = 10,
PASSWORD = '123456' --注意输入密码
GO