Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
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
up vote 4 down vote accepted

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.

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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