TDE Encryption yet again

  • Hello everyone,

    Does any one know if TDE Encryption uses CBC (Cipher Block Chaining) or ECB (Electronic Code Block)

    Thanks

  • The article describing TDE is here:

    http://technet.microsoft.com/library/cc278098(SQL.100).aspx#_Toc189384677

    Based on its description - it's CBC.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Thanks!!

    I read the white paper and it was there in black and white

    'Data is encrypted in the cipher block chaining (CBC) encryption mode. The encrypted database files that are written to disk are the same size as the unencrypted files because no extra padding is required and the initialization vector (IV) and encrypted DEK are stored within the existing space. Because the log is padded to the next VLF boundary, the log will grow in size. Note that while the database state is marked as Encryption enabled, the actual state of the encryption should be monitored through the DEK state. When the background scan is complete the DEK state is set to Encrypted. At this point, future writes to the log and to disk are protected.'

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

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