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/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.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, 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 Goncalves|||Didn't work, only 200MB less.
"Jens Sü�meyer" wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.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, 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 Goncalves|||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...
> Didn't work, only 200MB less.
> "Jens Süßmeyer" wrote:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.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,
>> > 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 Goncalves|||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 in
> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
> > Didn't work, only 200MB less.
> >
> > "Jens Sü�meyer" wrote:
> >
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.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,
> >> > 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 Goncalves
>
>|||Do you have text/ntext/image columns? In that case, see
http://support.microsoft.com/default.aspx?scid=kb;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...
> 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
>> in
>> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
>> > Didn't work, only 200MB less.
>> >
>> > "Jens Süßmeyer" wrote:
>> >
>> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.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,
>> >> > 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 Goncalves
>>