2

When does tempdb get encrypted with Transparent Data Encryption? What configuration, etc, causes tempdb to be encrypted this way?

2
  • 1
    I believe if you turn on TDE on any database in the instance, tempdb gets encrypted, too. Is that what you're getting at? The question is a bit unclear.
    – Jon Seigel
    Commented Sep 11, 2013 at 19:30
  • Yes, Jon, that's what I'm getting at. I'd love to find a better way to word/frame the question. Commented Sep 11, 2013 at 20:46

1 Answer 1

6

When you encrypt the first database in the instance, tempdb will also be encrypted. As per this reference on TDE:

Transparent Data Encryption and the tempdb System Database

The tempdb system database will be encrypted if any other database on the instance of SQL Server is encrypted by using TDE.

This will be the case when you set ENCRYPTION ON on a database.

2
  • 1
    Microsoft doesn't seem to include information about which certificate is used for tempdb. (E.g. if you use a separate certificate to encrypt different database catalogs.)
    – Granger
    Commented Oct 23, 2014 at 14:41
  • @Granger: While I don't know I have reason to believe the answer is "none of them".
    – Joshua
    Commented Mar 19, 2023 at 22:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.