cef1320c   
   From: esquel@sommarskog.se   
      
   Query Builder (querybuilder@gmail.com) writes:   
   > I really appreciate your response...   
   >   
   > The percent_complete says 0 for all the databases including the one   
   > which is still encrypting..   
   > is_encrypted = 1 for all Databases   
   > encryption_state = 2 for only this DB but everything else is 3.   
   >   
   > The mirroring to DR is also synchronized. I do see the backup size has   
   > grown to be about 81GB where it used to be about 25GB with   
   > compression. (The db size is actually 115GB).   
   >   
   > I am worried as its been almost 2 weeks. Any help would be much   
   > appreciated..   
      
   Since I don't work much with TDE, I consulted my MVP mates. One them   
   brought up this:   
      
      Sounds like a long-running transaction is preventing log truncation and   
      the log wrapping. IIRC the encryption_state won't switch to 2 until the   
      log wraps.   
      
      That would also account for the increasing backup size - as more and   
      more log needs to be included in the backup because of the long-running   
      transaction.   
      
      All from memory - so could be incorrect about the TDE thing. Ask him to   
      check log_reuse_wait_desc and DBCC OPENTRAN.   
      
   Is this applicable to your situation?   
      
   --   
   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)