Restoring the TDE Encrypted DB to Another Server
If a restore attempt of a TDE encrypted backup file is attempted, a failure such as the one shown in Figure 17.12 will occur. To be able to restore the backup file, the target server will need to have the TDE Certificate restored to it.
Figure 17.12. Viewing an error generated when attempting to restore a TDE-encrypted database from backup.
The high-level steps for restoring a TDE-encrypted database to another server are as follows:
- Create new DMK on target server. (Each DMK is unique, so simply create a new one using the TSQL listed in previous steps. This DMK does not need to match the one from ...