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.
- Vaulter
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.