set encryption off RRS feed

  • Question

  • Hi,

    I restore Master key after dropping it just to do tests and i restored certificate backed up .. i create a Database encryption key and finally i set encryption on .. when i want to disable TDE encryption, set it off , i have an error message :

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

    What does it mean ? what's the problem ? why i can't et encryption off ???



    Wednesday, February 16, 2011 6:03 PM


All replies