SQL 2005 - Database size

Mike

One of our db is assigned with 30 GB and set to autogrow. The issue we have
lately is that the db grow to 100 GB in a day thru a process in the
application.The purge process with in the application doesn't release the
space back to the server. This is causing space issue in that box which is
only 105 GB.

Curently we ran manually DBCC shrinkfile to get that db back into the
correct size.

Any thoughts/ideas for handling this issue without manually running DBCC
shrinkfile.

Thanks for your time.

TheSQLGuru

1) don't shrink the database size!
www.karaszi.com/SQLServer/info_dont_shrink.asp

2) make a cleanup process that purges unnecessary data on a regular basis
throughout the day, then the database won't increase much in size in the
first place.



--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.


"Mike" <Mike@discussions.microsoft.com> wrote in message
news:879D88A8-DC61-4150-B69D-32F387450193@microsoft.com...
> One of our db is assigned with 30 GB and set to autogrow. The issue we
> have
> lately is that the db grow to 100 GB in a day thru a process in the
> application.The purge process with in the application doesn't release the
> space back to the server. This is causing space issue in that box which is
> only 105 GB.
>
> Curently we ran manually DBCC shrinkfile to get that db back into the
> correct size.
>
> Any thoughts/ideas for handling this issue without manually running DBCC
> shrinkfile.
>
> Thanks for your time.