小試SQL SERVER 2014 加密備份

標籤：style   blog   http   color   io   ar   資料   2014   art   

?

?

?

?

資料庫加密：

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

?

createmasterkeyencryptionbypassword=‘[email protected]‘

?

backupmasterkeytofile=‘d:\smk.bak‘

encryptionbypassword=‘[email protected]‘

?

?

?

openmasterkeydecryptionbypassword=‘[email protected]‘

?

?

CREATECERTIFICATE BackupCertificater

?

WITHSUBJECT=‘Backup Encryption Certificate‘;

?

GO

?

?

BACKUPDATABASE Test TODISK=‘d:\Test_Encrypted.bak‘WITHCOMPRESSION, ENCRYPTION (ALGORITHM = AES_256, SERVERCERTIFICATE= BackupCertificater);

?

?

?

?

小試SQL SERVER 2014 加密備份