title: Check if my database instance on SQL server is encrypted by TDE?
body: <p>I have a question about SQL server's transparent encryption (TDE). I need to dump a database instance, which will be restored by another DBA remotely by dumped data files. I was asked to make sure the dumped data files has no TDE so DBA can restore it. I checked online, and I found a query to list the encryption status as follows:</p>
  
  <pre><code>SELECT db_name(database_id), encryption_state 
  FROM sys.dm_database_encryption_keys;
  </code></pre>
  
  <p>my database instance is not in the result at all. I run another query as follows:</p>
  
  <pre><code>SELECT
      db.name,
      db.is_encrypted,
      dm.encryption_state,
      dm.percent_complete,
      dm.key_algorithm,
      dm.key_length
  FROM
      sys.databases db
      LEFT OUTER JOIN sys.dm_database_encryption_keys dm
          ON db.database_id = dm.database_id;
  GO
  </code></pre>
  
  <p>My database instance has value 0 for <code>is_encrypted</code>, and all other values null.</p>
  
  <p>Does it mean my database instance is not encrypted at all?</p>