October 2010
Intermediate to advanced
1008 pages
46h 16m
English
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:
Read now
Unlock full access