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

?

@@#