Lost Database encryption (TDE) password, How to recover?

Raveendar Oddi 6 Reputation points
2022-02-03T09:21:22.123+00:00

Hi ,

Our DBA lost the password of the certificate with which our database was encrypted. We've to migrate the database to latest.
How can I recover? If I create a new on can I apply new cert to the DB?
Can I disable the TDE, then backup and restore then Encrypt? Is it possible and impact?

Thanks !

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

0 comments

1 answer

Sort by: Oldest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.