小试SQL SERVER 2014 加密备份

?

?

?

?

数据库加密：

http://blog.csdn.net/u012992506/article/details/25283035

?

create master key encryption by password=‘P@ssw0rd‘

?

backup master key to file=‘d:\smk.bak‘

encryption by password=‘P@ssw0rd‘

?

?

?

open master key decryption by password=‘P@ssw0rd‘

?

?

CREATE CERTIFICATE BackupCertificater

?

WITH SUBJECT = ‘Backup Encryption Certificate‘;

?

GO

?

?

BACKUP DATABASE Test TO DISK =‘d:\Test_Encrypted.bak‘WITH COMpreSSION, ENCRYPTION (ALGORITHM = AES_256, SERVER CERTIFICATE = BackupCertificater);

?

?

?

?