Re: Database Size.

Dale E. Reed Jr. ( (no email) )
Wed, 17 Jun 1998 17:04:44 -0700

Scott Burch wrote:
>
> I guess what I should have said is, what risk is there to doing the
> consolidation. Our database has crashed on us a few times this last week and
> I don't need anymore problems. But, I sure would like to shrink the size of
> our database. 900MB is a little ridiculous. Suggestions?

You can either do a consolidation, delete the older data, or truncate
the table. All will greatly affect your SQL Server during the operation
(except maybe the truncate).

I explained the consolidation in my previous post. If You wan to
do one of the others, let me know.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com