Post reply

Database snapshot, TDE, and sys.databases

  • May 19, 2023 at 4:20 pm

    #4193153

    Something I was looking at on a dev server where I was taking some snapshots and where we have TDE enabled and operational on the underlying database. Querying sys.databases shows the is_encrypted field as zero? Reading through the TDE documentation there is no exception that snapshots are NOT encrypted that I could find, but now I'm questioning things because of the is_encrypted field.

    Is this just a glitch? Maybe it just doesn't inherit the value for some reason.

  • May 19, 2023 at 5:10 pm

    #4193172

    Looked at sys.database_encryption_keys and the entries are there for the snapshot databases and claim that it is all encrypted, so now I'm leaning towards glitch. Still weird behavior though.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply