So, I may need to enable TDE on some DBs in the near future, and I want to get everything clear in my head. I understand the basics of enabling TDE, and I understand that losing the certificate (the DMK) *WILL* result in a non-recoverable database, period. But, I have some questions on *restoring* a TDE enabled DB.
I'm presuming, if I need to restore a copy from our production environment to our QA, I would have to import the certificate used into the QA server. Once that's done, I expect (and plan to test on my home system) that I would then be able to simply restore my backup to QA.
But. Of course there's a but. Our normal backups are taken using a 3rd party application, Commvault. I've already asked the CV admin to look into what's needed and even if CV can backup / restore TDE databases. So, question is, does anyone out there have experience with *any* 3rd party backup solution and TDE database backup and recovery? Is it possible? Is it similar (when restoring) to the process for "manual" backups?