Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2010-08-12 : 11:18:10
|
We are planning to enable TDE on some of our databases. And, I need to make all the loopholes have been covered before this major step. I am aware of some of the known issues (limitations) of TDE. (CPU intensive, encrypted tempdb causing performance hit for non-TDE dbs etc.)There are also some issues with restoring a db which had TDE enabled in the past. All these probably can be handled with some planning. However, does anyone know any critical things that need to be taken care of? Or did anyone face major issues because of enabling this feature?Are there any problems with DB maintenance when TDE is enabled? I found the following information on a MS site. (http://msdn.microsoft.com/en-us/library/bb934049.aspx)While a re-encryption scan for a database encryption operation is in progress, maintenance operations to the database are disabled. You can use the single user mode setting for the database to perform the maintenance operation. What is re-encryption scan?What maintenance operations will be disabled?------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
Known issues with TDE.