-----Original Message-----
From: Robert Boyle <robert@garden.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Sunday, June 14, 1998 11:22 AM
Subject: Re: Database Size.
>At 08:13 AM 6/13/98 -0400, you wrote:
>>
>> We have about 350 MBRs and appoaching 200Meg in size. I have run the SQL
>> scripts to delete the call records with little effect. I know there is
>> something else that needs to be done but don't know. I figure the db
>should
>> be about 60-70 Meg in size.
>
>
>
>Those are your calls. We have about 1450 MBRs and one month of calls and
our
>database is only 29MB. Is your log file on the same device? If so, think
about
>moving it to its own device.
>
>
>>
>>
>> Is there any other maintenance that needs to be done. I have seperated
the
>> logs for the emerald db so I know it is not the logs.
>
>
>
>Also try a:
>
>DBCC CHECKDB(Emerald)
>
>See what errors it lists.
>
>-Robert
>
>
>
>
>