From: querybuilder@gmail.com   
      
   database_name	database_size	unallocated space   
   A_DB	         411324.00 MB	196982.09 MB   
      
   reserved	data	         index_size	unused   
   215290792 KB	192933232 KB	14584032 KB	7773528 KB   
      
   The database has 3 Files associated to it..    
   name	fileid	size	        maxsize	        growth	usage   
   A_Data	1	212967424 KB	Unlimited	0 KB	data only   
   A_Log	2	4195328 KB	Unlimited	1048576 KB	log only   
   A_Data2	3	67718144 KB	Unlimited	0 KB	data only   
   A_Data3	4	136314880 KB	Unlimited	1048576 KB	data only   
      
   The database is sitting on an Active / Passive Windows Cluster. The database   
   version is SQL 2008 with SP2.    
      
   The database is also mirrored to a DR SQL Instance. We even tried taking it   
   off of mirroring and shrunk the database. Still no luck..    
      
   The issue I am facing is that one of the Data file (A_DATA) is sitting on a   
   drive which is 90% filled and We cleared a log table that was holding about   
   90GB space out of this file. I want to release the space to that drive. This   
   particular data file is    
   set to not grow.    
      
      
   Thanks in advance for your help. I look forward to any positive suggestions..    
      
   Regards   
   Aravin Rajendra.    
      
   On Thursday, January 10, 2013 5:20:58 PM UTC-5, Erland Sommarskog wrote:   
   > 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)