Sample Header Ad - 728x90

Impact of regenerating the master key with ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD on existing TDE encrypt databases and certificates

0 votes
1 answer
789 views
I have already (by accident) regenerated the master key in the master database of a (development)server that hosts multiple databases encrypted with Transparent Data Encryption (TDE). Now, I am curious about the effects of this action on the existing certificates and the databases encrypted with those certificates. Specifically, I would like to know: 1. What impact does regenerating the master key have on the encryption status of the existing databases that were previously encrypted with TDE? 2. After regenerating the master key, what happens to the certificates used for TDE encryption? Do they need to be reconfigured or regenerated? Do I need to take a new backup of the certificates/private key, or will the existing files still function when restoring to other servers? 3. Are there any necessary precautions or steps to take after regenerating the master key to ensure the integrity and accessibility of the encrypted databases? I want to ensure that regenerating the master key has not caused any unintended consequences, such as rendering my encrypted databases inaccessible or compromising their security (as of now I can query them normally). Any insights or advice on this matter would be greatly appreciated. Thank you!
Asked by GHauan (615 rep)
May 24, 2023, 02:33 PM
Last activity: Aug 23, 2024, 05:03 PM