June 16, 2009 at 10:57 am
Hi,
I have restored a back-up from a Sql server instance to another,but
was not able to decrypt using the asymmetric key even i tried recreating the master key and asymmetric key but was of no use.Please let me know if there is some way through which data can be decrypted.
Regards
Prasanna.
June 16, 2009 at 12:23 pm
I think you can't re-create the master key. I think you need to migrate it. If I remember correctly, in MSDN/BOL articles on encryption, it has data on how to do that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply