CREATE DATABASE ENCRYPTION KEY

Hi experts

i have execute this code
USE master;
ALTER DATABASE ConfidentialDB
SET ENCRYPTION ON;

whats the mean?
i execute this select
SELECT * FROM ConfidentialDB.dbo.SecretKeys
i can view the data,

which means that the db this encrypted? what are the advantages? although the bd is encrypted I can see the data in the table
enrique_aeoAsked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
Someone takes your log file, data file or back up file and take it any where so in order to make it safe we do Transparent Data Encryption.

Transparent Data Encryption (TDE) encrypts SQL Server data and log files. It performs real-time I/O encryption and decryption of the data and log files. It uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery.

You can check your files @ depending on the version-

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log

Read more here -

https://msdn.microsoft.com/en-us/library/bb934049.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.