Re: Database Size.

Robert Boyle ( robert@garden.net )
Sun, 14 Jun 1998 14:20:25 -0400

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