Re: Database Size.

Scott Burch ( (no email) )
Sun, 14 Jun 1998 19:45:56 -0700

We have the same problem..A HUGE DB. What command can we use to delete the
call information?

-----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
>
>
>
>
>