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 data with the new encryption key.
But how to use the Key Rotation with SQL Server 2005??
Below are specified a few details as to how you can go ahead and use the Key Rotation to change the key with which the data has been encrypted.
And with this you have the data encrypted with a new key and the old key has been dropped.
You can refer to this blog by Laurentiu Cristofor of the Microsoft SQL Server Security team for more details and the alternatives as well.
Sanjaya PadhiSE, Microsoft SQL Server
PingBack from http://hoursfunnywallpaper.cn/?p=507