sys.databases displays a value of 0 for 'is_encrypted' field of tempDB when TDE is enabled - by Akreul

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 808379 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/12/2013 12:59:03 PM
Access Restriction Public


According to the technet,, whenever TDE is enabled on a database, TDE is also automatically enabled on the tempDB database on the same instance.  When querying the sys.databses DMV, is_encrypted correctly displays a value of 1 for the database where we explicility turned on TDE, but still displays a value of 0 for tempDB.  If this is indeed automatically turned on for tempDB, this view should also be updated to avoid confusion.
Sign in to post a comment.