October 2010
Intermediate to advanced
1008 pages
46h 16m
English
There are a few requirements and limitations to TDE that should be known in advance of its deployment, as follows:
• The Enterprise edition of SQL Server is required for TDE. This version of SQL Server is considerably more expensive than the Standard edition.
• TDE does not encrypt the communication channel. IPsec is the solution for this.
• TDE cannot take advantage of SQL 2008 RTM/R2 backup compression.
• Replication or FILESTREAM data is not encrypted when TDE is enabled.
• The tempdb is encrypted for the entire instance, even if only one database is enabled for TDE.
Read now
Unlock full access