TravisDBA (7/6/2010)
What I don't understand is why Mickeysoft would include two new features like TDE and Backup Compresion that are not mutually compatible with each other. If you don't believe this then just try using TDE to encypt a database, then back it up using COMPRESSION and notice how the compression ratio is bascially nullified on an encpyted database using TDE. Great! so, you can encrypt a very large database using TDE with no problem, but you can't take advantage of the new backup compression of that database, so you are out of luck there, at least for now anyway. 🙂
Because encryption changes the entropy of the data, you need to always compress FIRST (whether database or any other) then encrypt. It does not work well the other way.
...
-- FORTRAN manual for Xerox Computers --