Reserved Space

I have a 8GB database, witch only 2,5GB is used by the database itself, the
rest is identified as reserved space. How do i shrink the reserved space or
limit it's size?
The databese keeps growing and almoust all the growing is related to the
Reserved Space.
Humberto Goncalveshttp://msdn.microsoft.com/library/d...
pd1.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Humberto Goncalves" wrote:

> I have a 8GB database, witch only 2,5GB is used by the database itself, th
e
> rest is identified as reserved space. How do i shrink the reserved space o
r
> limit it's size?
> The databese keeps growing and almoust all the growing is related to the
> Reserved Space.
> Humberto Goncalves|||Didn't work, only 200MB less.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> http://msdn.microsoft.com/library/d...r />
_3pd1.asp
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Humberto Goncalves" wrote:
>|||Try reorging your tables (i.e. rebuilding clustered indexes) and then the
SHRINKDATABASE).
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...[vbcol=seagreen]
> Didn't work, only 200MB less.
> "Jens Smeyer" wrote:
>|||Already done that, no changes.
I've got more 600MB, but i can't go further than this.
Still 3,5GB missing...
"Dan Guzman" wrote:

> Try reorging your tables (i.e. rebuilding clustered indexes) and then the
> SHRINKDATABASE).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote i
n
> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
>
>|||Do you have text/ntext/image columns? In that case, see
http://support.microsoft.com/defaul...b;en-us;324432. Also, check
to ensure you have clustered indexes on your tables, especially the large
ones.
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:EA8967E8-B826-4231-A556-69E51A86A73D@.microsoft.com...[vbcol=seagreen]
> Already done that, no changes.
> I've got more 600MB, but i can't go further than this.
> Still 3,5GB missing...
> "Dan Guzman" wrote:
>