Skip to main content
Question

Restore SQL database with TDE encryption

  • 27 September 2024
  • 1 reply
  • 90 views

Forum|alt.badge.img+2

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.

1 reply

Forum|alt.badge.img+7
  • Vaulter
  • 68 replies
  • September 28, 2024

hi @Kamesh  if it is SQL onpremise ( you will need keys to be imported for the restored DB)
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
 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings