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.

image

The high-level steps for restoring a TDE-encrypted database to another server are as follows:

  1. 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 ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial