Cannot drop the database encryption key because it is currently in use

1 vote

1 answer

1208 views

                          I want to create a backup of my sql managed instance database to blob storage. However am encountering the below error after trying to turn off encryption key as follows:

    use master
    ALTER DATABASE [db1] SET ENCRYPTION OFF;
    
    use [db1]
    DROP DATABASE ENCRYPTION KEY
    GO

    Msg 33105, Level 16, State 1, Line 6
    Cannot drop the database encryption key because it is currently in use. Database encryption needs to be turned off to be able to drop the database encryption key.

I have read all MS documentation and everything is pointing to what I have done above.

What am I doing wrong here?
                        

Asked by Immortal (121 rep)

Dec 8, 2023, 09:14 AM
Last activity: Sep 17, 2025, 07:02 PM

Cannot drop the database encryption key because it is currently in use

Related Questions