0

Is it possible to take a database that is using TDE and create a backup file that is not encrypted?

I know that I could create a backup, import into another database (using the key and certificate), turn off TDE and create a backup.

I'm wondering if there is a more straight forward approach.

yamspog
  • 18,173
  • 17
  • 63
  • 95

1 Answers1

0

nope. that would defeat the purpose of TDE. if backup was unencrypted then anyone could get an easy copy of the database.

yamspog
  • 18,173
  • 17
  • 63
  • 95