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