jasona.work (3/22/2014)
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?
Thanks,
Jason
To restore a TDE enabled database to a new instance of SQL server you need the database backup and a backup of the certificate from the source server that is used to protect the database encryption key.
It's all in my guide at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉