Thanks Dale.
>Network Operation Centre wrote:
>>
>> >> So how do I dump a lot of the history because this is what I think is
>> taking
>> >> up so much disk space ?
>> >
>> >The only thing that really takes up disk space is the Calls table.
>> >One year of billing history for 10,000 users would be maybe 50mb or
>> >so.
>>
>> Well I only have about 1300 users active, but all up I think we have
about
>> 6000MBRS and as I said the data base has three files which are over
300mb.
>>
>> >I would trim out calls over 3 months old and then run the checkdb.sql
>> >script to see if it fixes the sizes.
>>
>> This is what I can not do. The trim option will not highlight
>
>Make sure you are doing calls, and that you do the summary first.
>Once the summary is displayed, it will then let you do a trim on
>the calls.
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart