You are correct. This question is a mess. Set everything back to log since that was the original title. Should be OK now.

If any of you are interested, we'd love some new articles on solving any of the T-SQL issues you've answered in the forums. We're a little short of content and...

The question is what is being asked. The title was incorrect, but changed, however, you should not base your answer on the title.

I agree. I'm only doing these questions so people are aware if they run into the strange situation.

You can open in an editor, but you really need a hex editor. Here's a backup of my sample database before I enable TDE.

Note the offset: 29252A....

I'll look at source control in a later article.

Thank you and happy to help.

Note that you will get some logging as pages change and they are decrypted. If you encrypt again, it's online, but more logs.

Like most software places, Microsoft is composed of people, who are not consistent in what they do.

Someone likely defined the build versions in some method and over...