InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:03:16 GMT20http://www.sqlservercentral.com/Forums/Topic958329-391-1.aspxYou need to create the encrytion key from the backup of the encrytion key from the source DB server.Please check the following article:http://www.sqlservercentral.com/articles/Transparent+Data+Encryption/66334/Mon, 26 Jul 2010 01:00:29 GMTMinazhttp://www.sqlservercentral.com/Forums/Topic958329-391-1.aspxAfter 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 1The 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.Fri, 23 Jul 2010 16:29:42 GMTForgottenOne