备份加密密钥

本文介绍了备份加密密钥的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好，

我们如何使用T-SQL创建Symmetic和Asymmetric Keys的备份？

How we create backup of Symmetic and Asymmetric Keys using T-SQL?

谢谢，

Ashru

MCTS，http：//asharafaliptb.wordpress

MCTS, asharafaliptb.wordpress

推荐答案

您无法备份非对称密钥！

www.sqlservercentral/blogs/ steve_jones / 2009/05/04 / backup-up-asymmetric-keys /

www.sqlservercentral/blogs/steve_jones/2009/05/04/backing-up-asymmetric-keys/

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'My p@55w0Rd'; GO CREATE CERTIFICATE [cert_keyProtection] WITH SUBJECT = 'Key Protection'; GO CREATE SYMMETRIC KEY [key_DataShare] WITH KEY_SOURCE = 'My key generation bits. This is a shared secret!', ALGORITHM = AES_256, IDENTITY_VALUE = 'Key Identity generation bits. Also a shared secret' ENCRYPTION BY CERTIFICATE [cert_keyProtection]; GO

打开对称密钥

OPEN SYMMETRIC KEY [key_DataShare] DECRYPTION BY CERTIFICATE cert_keyProtection; GO SELECT encryptbykey(key_guid('key_DataShare'), 'MyData' ) GO -- For example, the output might look like this: 0x2152F8DA8A500A9EDC2FAE26D15C302DA70D25563DAE7D5D1102E3056CE9EF95CA3E7289F7F4D0523ED0376B155FE9C3

参考 更多信息。