August 22, 2020 at 12:45 pm
Hi Steve,
something has gone wrong here, there is no link back to the article from this discussion thread as it is as stated, not currently available on the site, but why is the discussion available?
😎
August 22, 2020 at 4:51 pm
A scheduling mishap. This thread shouldn't be visible either.
August 26, 2020 at 12:00 am
Comments posted to this topic are about the item Removing TDE from a Database: Level 4 of the Stairway to TDE
August 26, 2020 at 12:57 pm
I love articles like this, explosing the hidden gotcha. Thanks for sharing.
September 22, 2023 at 4:31 pm
BTW, I found another "gotcha". After turning off encryption stats off for the only encrypted database on the instance, encryption_state was still 1, and tempdb was showing up as encrypted. The drop DEK statement generated an error. I bounced the instance, no change. Finally I dropped the formerly encrypted database, and still got the error trying to drop the DEK. Finall I just tried removing the certificate, and it worked. The DEK was gone as well. Apparently there's also a known bug in updating the DMV for tempdb as well. It's described as "benign", but it certainly doesn't seem so when trying to back out the encryption, such as in this scenario.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply