网游之天地男儿,家长会黑板报,今日新闻联播内容
参考
select db_name(database_id) as databasename, * from sys.dm_database_encryption_keys;
go
use master;
create master key encryption by password = '$$$$';
use master;
create certificate backupcert with subject = '备份证书';
use master;
backup certificate backupcert to file = 'c:\data\dbbak\bj_yun\backupcert.cer'
with private key ( file = 'c:\data\dbbak\bj_yun\backupcert.pkey', encryption by password = '$$$$' );
--还原证书
create certificate backupcert from file = 'c:\temp\backupcert.cer'
with private key ( file = 'c:\temp\backupcert.pkey', decryption by password = '$$$$');
@@#
还原时,无法解开备份集
进行密钥及证书导入后重新还原,文件被解开,可以列出备份集中的数据库名,正常还原
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论