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.
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)