• Which part of "sorry, you can't" was unclear to you?

    The Books Online topics on TDE are littered with warnings about backing up your certificate. For instance here:

    "Data loss will result if the certificate is no longer available".

    I am very sorry, but this feature is designed to be safe. The whole idea is that if someone, somehow gains entry to my data center and steals the data disk, they can make some money by selling it as used storage hardware but they will not be able to get at my data. If there was any way to reverse the encryption, then no sane company would ever entrust their sensitive data to this database.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/