TDE : Transparent Data Encryption
USE master; GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘P@ssw0rd’; go CREATE CERTIFICATE DB_TDE_Cert WITH SUBJECT = ‘DBTDE_Cert’; –Backup the key USE master; OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘P@ssw0rd’; BACKUP MASTER KEY TO FILE = ‘C:\data\EncryptionDemo\DBTDE_Cert.key’ ENCRYPTION BY PASSWORD =’P@ssw0rd’; GO BACKUP CERTIFICATE DB_TDE_Cert TO FILE = ‘C:\data\EncryptionDemo\DBTDE_Cert.bak’ WITH PRIVATE KEY ( […]