Cannot load database because

Question

Dear colleagues,

When restoring a database I get the following error.

Msg 33111, Level 16, State 3, Line 2
Cannot find server certificate with thumbprint '0x75D2A59C56AD370011001C8DA03DBAD5647C96C0'.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

The database was TDE encrypted on the original server, but I disabled encryption, and removed the certificate and master key prior to making a backup. Anybody any idea what I'm missing?

Thanks.

Answer 1

Found it. My bad. The answer, don't forget the following statement:

DROP DATABASE ENCRYPTION KEY;