locked
TDE Encryption_State = 2 And Precent 0% stuck in State 2 – Encryption in Progress RRS feed

  • Question

  • hi

    when run command ALTER DATABASE AmirDB SET ENCRYPTION ON

    stuck in state 2 - Encription in Progress

    and when run ALTER DATABASE AmirDB SET ENCRYPTION OFF

    Error :

    Msg 33109, Level 16, State 1, Line 25
    Cannot disable database encryption while an encryption, decryption, or key change scan is in progress.
    Msg 5069, Level 16, State 1, Line 25
    ALTER DATABASE statement failed.

    and when Restart Sql Server , DataBase  AmirDB(Recovery Pending)

    Please help.

    thanks


    Tuesday, August 2, 2016 12:21 PM

Answers