security certificate and symmetric keys

Last Post 14 Jan 2013 11:33 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
New Member
New Member

14 Jan 2013 11:33 AM
I need to recreate certificate and symmetric key from database Proddb in database TestDB.

I have backed up certificate to a file and recreated it in my Testdb database (using the cert backup file)
Now i need to recreate Symmetric key. And i cant figure out how.
I found this great article winch explains the issue, and it seems like its no big deal to recreate it, but i have to know IDENTITY_VALUE and Key_Source values and i don't have it. All i have is the password that was used to encrypt data in my Proddb

My question is: Does anyone know how to recreate Symmetric Key?

Here is the link to the above mentioned article
Also Microsoft similar article here

Thank you all for your help.

Acceptable Use Policy