1 Create a Master Key

2 Create a Certificate

3 Create a Database Encryption Key

4 Enable TDE

5 참고자료

USE master;
CREATE MASTER KEY 
ENCRYPTION BY PASSWORD = 'Pass@word1';
GO

USE master;
CREATE CERTIFICATE TDECert 
WITH SUBJECT = 'TDE Certificate'
GO

CREATE DATABASE mssqltips_tde
GO
USE mssqltips_tde;
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDECert
GO

ALTER DATABASE mssqltips_tde
SET ENCRYPTION ON
GO
SELECT [name], is_encrypted FROM sys.databases
GO

• SQL Server Transparent Data Encryption (TDE) Performance Comparison
  
• http://www.sql-server-performance.com/articles/dba/Transparent_Data_Encryption_p1.aspx
  
• Transparent Data Encryption (TDE) SQL Server 2008
  
• Understanding transparent data encryption in SQL Server 2008