I tried to restore an unencrypted database to a different server and it failed with the error:
"Cannot find certificate with thumbprint".
This suggests the database is encrypted but it is not. There are other databases on this server that are encrypted, but not this one.
When I query the
sys.dm_database_encryption_keys table the
encryption_state for this database is
1 = Unencrypted.
I see other databases where the encryption_state value is
NULL = Not Encrypted.
So I have 2 questions:
- What the difference is between the values NULL and 1?
- Why am I getting this error on an Unencrypted database?
Thank you for your time considering my question.