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

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

Re: Help with shrinking a database

Show all headers | View raw

Query Builder (querybuilder@gmail.com) writes:
> 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

So of a total database size of 215 GB, you have 7 GB of unused space.
This database does not need to shrink - it needs to grow. Exactly
how much depends how data you add to if of course. But the key is
that, while there is an autogrow function, it is nothing you should
rely on, but the database show be pre-grown in a controlled fashion.

Out of the blue, I would suggest adding 50 GB of breathing space.
 
> 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. 
 
Well, you might have deleted 90 GB of data, but that does not show in 
the numbers above. Is that log table by chance a heap?

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