Thursday, April 2, 2015

Checklist for Restoring TDE Encrypted database on different SQL Server

In order to perform a successful restore, we'll need the database master key in the master database in place and we'll need to restore the certificate used to encrypt the database, but we'll need to make sure we restore it with the private key. In checklist form:
  • There's a database master key in the master database.
  • The certificate used to encrypt the database is restored along with its private key.
  • The database backup to be restored.

No comments:

Post a Comment