[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

Restore TDE database to a different server

Can a database encrypted with TDE then unencrypted ever be restored to a different server without the keys?
0
vbplayer
Asked:
vbplayer
1 Solution
 
Mark WillsTopic AdvisorCommented:
Here is a little Quote from Microsoft:

When enabling TDE, you should immediately back up the certificate and the private key associated with the certificate. If the certificate ever becomes unavailable or if you must restore or attach the database on another server, you must have backups of both the certificate and the private key or you will not be able to open the database. The encrypting certificate or asymmetric should be retained even if TDE is no longer enabled on the database. Even though the database is not encrypted, the database encryption key may be retained in the database and may need to be accessed for some operations.



Meaning you MUST have certificate and the private key available to restore.

Have a look at : http://msdn.microsoft.com/en-us/library/bb500326.aspx

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now