Transparent Data Encryption (TDE)

External Article

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

External Article

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

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Advice I Like: Take Two Trips

By

If you have any doubt about being able to carry a load in one...

Read the latest Blogs

Forums

Is there an ISERROR equivalent in SS?

By water490

Hi everyone I have a SP that just failed.  Format of SP is: Select...

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers