I'm trying to disable TDE in SQL Managed Instance(Service Managed). After executing Alter statement for the DB (set encryption off), when I check sys.dm_database_encryption_keys for status, getting below output.
DB Name encryption_state_desc percent_complete encryption_scan_state_desc Encryption_State
TestDB PROTECTION_CHANGE_IN_PROGRESS 0 ABORTED 6
Is there a reason why it is stuck in aborted state (PROTECTION_CHANGE_IN_PROGRESS). Turning it ON is also not working, as Alter DB set encryption on is failing on the DB. There's no error message in SQL Log
Thankyou inadvance for your help.
- This topic was modified 1 year, 5 months ago by cooldude001.