TDE issue in SQL MI

• cooldude001

  Mr or Mrs. 500

  Points: 528

  More actions

  September 12, 2022 at 10:09 am

  #4086554

  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 2 years, 3 months ago by  cooldude001.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  September 13, 2022 at 10:10 am

  #4086993

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.