TDE issue in SQL MI

  • Hi,

    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, 9 months ago by  cooldude001.
  • 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)

You must be logged in to reply to this topic. Login to reply