• 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. 🙂

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"