I would appreciate if any one can help me out regarding the following
situation.



I created one database that has sensitive information in it so that I have
implemented Symmetric AES_128 Algorithm implemented and changed all the
stored procedure to first open the Symmetric Key and use the Decrypt
function is select stored procedure and close the Symmetric key at the end
of the stored procedure and same as for Insert and update stored procedure I
used open key at the first line and use encrypt function to encrypt the data
and close the key at the end of stored procedure. Now some how my manager
told me to me to move this database into different Server, I restore the
same database into different server and when I point the application to that
new server database it doesn't work and its not properly encrypted and
decrypted the data, Should I have to do anything after I restore the
database into another server so that I decrypt the data? I would highly
appreciate if any one can help me out, the problem is a sensitive data and
it's not decrypting.



Thanks in advance.

Hi Noor,

You have to backup/restore the database master key and restore that also.
THe master key is not backed up in the full database backup.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese

Alright, that means we don't need to re-create master key, Certificate and
symmetric Key?

Thanks Mohit


[quoted text, click to view]