Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restored backup database and now encryption doesn't work. Expand / Collapse
Author
Message
Posted Friday, July 23, 2010 4:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 26, 2010 1:27 PM
Points: 1, Visits: 13
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.
Post #958329
Posted Monday, July 26, 2010 1:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:50 PM
Points: 553, Visits: 1,577
You 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/


"More Green More Oxygen !! Plant a tree today"
Post #958602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse