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

  • 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 Sep 11 '13 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. – BrianCooksey Sep 11 '13 at 20:46

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.

  • 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 Oct 23 '14 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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