Forum Discussion

Vadim_s's avatar
Vadim_s
Copper Contributor
Sep 29, 2022

TDE decryption stuck

Hi team,

 

I started the process to decrypt TDE one of my database on SQL Server 2017 Enterprise. 

The process started OK and I could see the percentage, but after 30% the percent_complete is back to 0%

 

The database is still in "Decryption in progress" state. Any suggestions?

 

Warm regards,

Vadim

 

 

1 Reply

  • Vadim_s's avatar
    Vadim_s
    Copper Contributor
    Oct 06, 2022

    Vadim_s OK. The solution is - to run this query one more again.
    USE master;
    GO
    ALTER DATABASE dbname SET ENCRYPTION OFF;
    GO