e439d37e   
   XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   Query Builder (querybuilder@gmail.com) writes:   
   > I implemented TDE on one of my SQL Server instance. When I query the   
   > database state with the following query it returns 2 to one of my   
   > databases which is about 110GB. Its been 2 weeks and its still says   
   > 2.   
   >   
   > SELECT db_name(database_id), encryption_state,*   
   > FROM sys.dm_database_encryption_keys   
   >...   
   > I would greatly appreciate if anyone can shred some light on this and   
   > confirm that the encryption is complete. How do I confirm that the   
   > encryption is complete?   
      
   Well, if it says 2, that would indicate that it is not complete. What does   
   the other columns in this DMV report for this database? Particularly, what   
   does percent_complete report?   
      
   I found   
   http://www.simple-talk.com/sql/database-administration/transparent-data-   
   encryption/   
   which suggests some alternate ways to verify completion.   
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)