PHXHoward (1/28/2013)
Hi everyone.At what point does the actual data get reencrypted by SQL Server? Does it happen when I regenerate a database encryption key or when a new certificate is created and associated with an encrypted database?
Are you talking about Transparent Data Encryption (TDE) or cell encryption with crtificates and keys?
PHXHoward (1/28/2013)
When the data itself is reencrypted, is there a security issue during the decrypt/reencrypt process?None of the Microsoft documents seem to address this.
Thanks much.
I don't know about any issue but you should rember that when you have debug permission on OS level and none permission to SQL server you can read encrypted data from memory...and do many more things 😉