Asymmetric_keys

  • 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.

  • 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