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

Daily Coping 17 Sep 2021

By

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

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

All the Tools in Your Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

All the Tools in Your T-SQL Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

Get value of rows based on condition

By IdealPR

Hello, I have the table with data as bellow : create table tbl_Fact( IdCmd...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers