数据库备份启用加密

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 = '$$$$');

?

@@#