If a database is TDE encrypted, what is the process to successfully backup this database as a .bak file and export to third-party vendor? Here's my process so far.
Unencrypt the database by using ALTER DATABASE [databaseName] SET ENCRYPTION OFF;
Backup the database
Once database backup in step 2 above is completed, re-encrypt the database by ALTER DATABASE [databaseName] SET ENCRYPTION ON;
However, this steps did not work. When the vendor try to reimport the database, the error keep saying, "Cannot find server certificate with thumbprint" and then it shows the thumbprint. Am I missing something here? I thought once it's decrypted, it's no longer needed a cert to restore.