备份的数据库首次还原后可能出现打不开的情况，需执行以下

--------------------忘记密码了 删除掉----------------
DROP SYMMETRIC KEY[SymmetricKeyCert]

DROP CERTIFICATE [CertRSA]

drop master key

-------------------- 重新创建 -------------------------
–创建Master KEY
CREATE MASTER KEY ENCRYPTION BY PASSWORD= N’NewPassword’;

–创建证书
CREATE CERTIFICATE [CertRSACertRSA]
AUTHORIZATION [dbo]
WITH SUBJECT = N’Certificate’, START_DATE = N’1/12/2015 00:00:00’, EXPIRY_DATE = N’12/31/2050 00:00:00’
ACTIVE FOR BEGIN_DIALOG = ON;

–创建秘钥
CREATE SYMMETRIC KEY [ymmetricKeyCert]
AUTHORIZATION [dbo]
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE [CertRSACertRSA]

-------------备份的数据库还原后可能出现打不开的情况，需执行以下-------------

–用密码打开Database master key
OPEN MASTER KEY DECRYPTION BY PASSWORD=N’NewPassword’

–向服务器提供DMK （使用服务主秘钥 （SMK）加密），以后就可以自动解密了

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD =N’NewPassword’