Msg 15320, Level 16, State 2, Line 1

  • I have refreshed DB 'A' from server 'A' to server 'B'..And ran these scripts But after running second step I am getting below specified error message.

    open master key decryption by password = 'password';

    alter master key regenerate with encryption by password = 'password';

    close master key;

    An error occurred while decrypting asymmetric key 'asym_key' that was encrypted by the old master key. The FORCE option can be used to ignore this error and continue the operation, but data that cannot be decrypted by the old master key will become unavailable.

    Note [ is_master_key_encrypted_by_server=1 in sys.databases]

    please let me know if you need any other details...

    Thanks in Advance..

    Krishna

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply