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

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

Re: Help with shrinking a database

Show all headers | View raw

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.. 

Any help would be much appreciated... 

Thanks in advance.. 
Aravin Rajendra. 


On Thursday, January 10, 2013 2:58:40 PM UTC-5, Erland Sommarskog wrote:
> Dom (dolivastro@gmail.com) writes:
> 
> > I don't want to kill it, because I think I might lose data.  How do I
> 
> > get out of this?
> 
> 
> 
> You can kill it; it is transactional.
> 
> 
> 
> And there is a very simple way to avoid that this happens again: stop
> 
> shrinking your database! Shrinking a database that is going to grow
> 
> again is completely pointless. Shrinking is something you should use
> 
> only exceptionally. For instance, you take a copy of a production database
> 
> for development, but delete most of the data. Or you have had some
> 
> accident that inflated the database.
> 
> 
> 
> Shrinking introduces lots of defragmentation, so you need to run 
> 
> reindexing once shrink has completed (or you have stopped it). And
> 
> since reindexing needs free space, the database might grow again...
> 
> 
> 
> 
> 
> -- 
> 
> 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