After an issue with my database I did a full backup restore of my database that I backed up the previous day. After the restore I got the following error whenever I tried to perform any decrypt functions:
Please create a master key in the database or open the master key in the session before performing this operation.
I tried the following command:
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'my password';
but I end up with the following error:
Msg 15313, Level 16, State 1, Line 1
The key is not encrypted using the specified decryptor.
Is there any way I can decrypt my data? Not sure why I can't open my MASTER Key.
Any help would be greatly appreciated.