Cannot load database because

Chris Sijtsma 40 Reputation points
2023-12-04T10:02:26.0966667+00:00

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.

db_

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,320 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,597 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Chris Sijtsma 40 Reputation points
    2023-12-04T10:48:31.9533333+00:00

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

    DROP DATABASE ENCRYPTION KEY;

    0 comments No comments