Hi AndreyLau-2325,
I have a question: how to rotate the key without destroying the SQL database? What's the script?
Next is the process to rotate the keys and certificates used for TDE encryption:
- Create a new SQL TDE certificate;
- Backup the new SQL TDE certificate;
- Create the same SQL TDE certificate;
- Change encryption key for your databases;
More detail steps and codes you can reference : rotate-tde-keys&certificates
And this could be helpful: key-rotation-in-tde, SmartKey
BR,
Mia
If the reply helped, do "Accept Answer" and upvote it.--Mia.