Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the … Continue reading
Tag Archives: Encryption
Regeneration of the Master Key fails when we try to take the backup of the original database and restore it on other instance of sql server on some other server
TweetWe have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key … Continue reading