鸿 网 互 联 www.68idc.cn

当前位置 : 服务器租用 > 网站安全 > 加密解密 > >

小试SQL SERVER 2014 加密备份

来源:互联网 作者:佚名 时间:2015-09-03 09:42
? ? ? ? 数据库加密: 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 decr

?

?

?

?

数据库加密:

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

?

?

?

?

网友评论
<