I have taken backup from the live environment and trying to use it on the local box. The database in the live is encrypted with a key.
I have restored the database to localbox and cannot run any stored procedures as I have the following issue
Please create a master key in the database or open the master key in the session before performing this operation.
could anybody have faced this issue and how did you managed to solve. could you provide the answer step by step ?
I know the passowrd for the encrption on the live DB.