I disabled TDE on a database and once completed I dropped the DB certificate for it. Later I performed a manual failover to node2 and ran steps to enable TDE once again. However encryption state is stuck in state 2 with 0% of progress.
The error log shows:
Database Encryption scan for database was aborted. Reissue ALTER DB to resume the scan.
Every time I reissue the alter statement to turn encryption on it shows the same error. If I try setting encryption off I get an error that an encryption process is ongoing and can't get turned off.
I read this question but when I try to delete the certificate it gives me an error that the certificate is in use.