小试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);