Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1380

Re: Help with shrinking a database

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-10 05:15 -0800
  Re: Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-10 05:24 -0800
  Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-10 20:58 +0100
    Re: Help with shrinking a database Query Builder <querybuilder@gmail.com> - 2013-01-10 13:54 -0800
      Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-10 23:20 +0100
        Re: Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-11 05:03 -0800
          Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-11 14:39 +0100
        Re: Help with shrinking a database Query Builder <querybuilder@gmail.com> - 2013-01-11 13:46 -0800
          Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-11 23:28 +0100

csiph-web