I read it a few hours ago. It is a really helpful article. The BOL should state those recommendations.

Thanks for posting it!

Yes, the RemoveTDE.sql script take control of that. Am I the only one that got "suspect" DB when run RemoveTDE.sql and "restart" the instance? :blink:

Hi Sean, I think there are some misunderstood here. My issues are when a I remove TDE and restart the instance, not to configure, restoring or test TDE.

What I did...

Sean, thanks for your reply.

I created a new master key because in real world maybe I need to restore a TDE DB backup on a server with encrypted content (secured...

First of all, many thanks for your time and for share these useful set of scripts.

Secondly, I really appreciate your help to understand some issues that I have.

My scenario:

I successfully...