Restored backup database and now encryption doesn't work.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Restored backup database and now encryption...

Restored backup database and now encryption doesn't work.

Rate Topic

Display Mode

Topic Options

Author

Message

ForgottenOne

Posted Friday, July 23, 2010 4:29 PM

Forum 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

Minaz

Posted Monday, July 26, 2010 1:00 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, April 21, 2013 10:57 PM
Points: 535, Visits: 1,423

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 »

Permissions