We are backing up SQL database with TDE encryption. Could we restore the encrypted database to original server or different server without any encrypted key.
Solved
Restore SQL database with TDE encryption
+2- Novice
Best answer by Sujay kumar
hi
https://documentation.commvault.com/2022e/expert/18208_back_up_sql_server_data.html
If TDE or Always Encrypted is enabled, then the following rules apply:
--If the restore destination is a different client or instance, then the SQL administrator must back up the encryption key, and present it to the destination instance.
if it SQL on azure, please refer details in below post, you will still need encryption keys managed and imported seperately
- Vaulter
- Answer
hi
https://documentation.commvault.com/2022e/expert/18208_back_up_sql_server_data.html
If TDE or Always Encrypted is enabled, then the following rules apply:
--If the restore destination is a different client or instance, then the SQL administrator must back up the encryption key, and present it to the destination instance.
if it SQL on azure, please refer details in below post, you will still need encryption keys managed and imported seperately
Readiverse Academy Certifications
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.