Msg 15581 Please create a master key in the database or open the master key in the session

今天测试将加密的数据库还原到另外一台服务器，执行解密代码的时候出现下面的错误信息：

 

Msg 15581, Level 16, State 3, Line 1

Please create a master key in the database or open themaster key in the session before performing this operation.

 

解决办法1：用密码打开Database Master key

 

解决办法2：可以还原服务主密匙。