X-Received: by 10.224.218.2 with SMTP id ho2mr47987647qab.8.1357940764348; Fri, 11 Jan 2013 13:46:04 -0800 (PST) Received: by 10.49.75.195 with SMTP id e3mr14400073qew.24.1357940764329; Fri, 11 Jan 2013 13:46:04 -0800 (PST) Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!p13no1067698qai.0!news-out.google.com!k2ni225qap.0!nntp.google.com!p13no1067695qai.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Fri, 11 Jan 2013 13:46:04 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=63.240.94.244; posting-account=PgKd2woAAADMEPoOHlv-FZYtrlmqlSnd NNTP-Posting-Host: 63.240.94.244 References: <6918100a-d4c7-4714-8f16-20e7334ff1ab@d4g2000vbw.googlegroups.com> <4c1077a1-7473-4de3-9cfd-d0891270d498@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <09eb6a17-cfbd-4c1a-ad7e-ee5ed25f062e@googlegroups.com> Subject: Re: Help with shrinking a database From: Query Builder Injection-Date: Fri, 11 Jan 2013 21:46:04 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: csiph.com comp.databases.ms-sqlserver:1380 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..=20 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 databas= e version is SQL 2008 with SP2.=20 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..=20 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 abou= t 90GB space out of this file. I want to release the space to that drive. T= his particular data file is set to not grow.=20 Thanks in advance for your help. I look forward to any positive suggestions= ..=20 Regards Aravin Rajendra.=20 On Thursday, January 10, 2013 5:20:58 PM UTC-5, Erland Sommarskog wrote: > Query Builder (querybuilder@gmail.com) writes: >=20 > > I have this issue with one of my Database. I have a database which is >=20 > > TDE enabled. I did a data purge of one of the table which was holding >=20 > > several million rows of data. Normally I dont shirnk the database but >=20 > > this time, its alot of space and is increasing the backup size because >=20 > > of TDE. Now I want to release the space to the Drive. I have tried >=20 > > several ways to shrink: I tried thru the GUI and it just closes but >=20 > > doesnt shrink I tried thru the GUI to release only a few GBs but nothin= g >=20 > > is changing. I tried thru Query window, no luck.=20 >=20 > >=20 >=20 > > Is there a problem shrinking Database which are TDE enabled? I ran into >=20 > > an issue with one of my other DB which is also TDE Enabled..=20 >=20 >=20 >=20 > What does sp_spaceused report for the database? I want both result sets. >=20 >=20 >=20 > --=20 >=20 > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se >=20 >=20 >=20 > Links for SQL Server Books Online: >=20 > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >=20 > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx