Transparent Data Encryption (TDE)

How to Move a TDE Encryption Key to Another SQL Server Instance

  • Article

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.

2018-02-20

2,970 reads

Encrypting SQL Server: Transparent Data Encryption (TDE)

  • Article

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.

2017-03-24

5,410 reads

Blogs

Nerd Journey Podcast with Nick Korte

By

I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey....

Daily Coping 18 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a configurable SSMS script

By

Several times over the last few weeks I’ve gotten a request to create a...

Read the latest Blogs

Forums

Hostage Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hostage Data

Multiplying Vectors in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiplying Vectors in R

Hidden Pitfalls with INNER JOIN and NOT IN Operators

By MMartin1

Comments posted to this topic are about the item Hidden Pitfalls with INNER JOIN...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers