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:
[color=#FF0000]Please create a master key in the database or open the master key in the session before performing this operation.[/color]
I tried the following command:
[color=#FF0000]OPEN MASTER KEY DECRYPTION BY PASSWORD = 'my password';[/color]
but I end up with the following error:
[color=#FF0000]Msg 15313, Level 16, State 1, Line 1
The key is not encrypted using the specified decryptor.[/color]
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.