From: esquel@sommarskog.se   
      
   Query Builder (querybuilder@gmail.com) writes:   
   > I have this issue with one of my Database. I have a database which is   
   > TDE enabled. I did a data purge of one of the table which was holding   
   > several million rows of data. Normally I dont shirnk the database but   
   > this time, its alot of space and is increasing the backup size because   
   > of TDE. Now I want to release the space to the Drive. I have tried   
   > several ways to shrink: I tried thru the GUI and it just closes but   
   > doesnt shrink I tried thru the GUI to release only a few GBs but nothing   
   > is changing. I tried thru Query window, no luck.   
   >   
   > Is there a problem shrinking Database which are TDE enabled? I ran into   
   > an issue with one of my other DB which is also TDE Enabled..   
      
   What does sp_spaceused report for the database? I want both result sets.   
      
   --   
   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)