RE: Call consolidation and Calls table

Michael Whisenant ( )
Wed, 17 Dec 1997 20:23:15 -0600

This could be rather interesting! Questions that I have are how many
ports and how many records do you log in a month? How large is your normal
Emerald database and is this table inside the same database? Or in another
database on the same SQL server? I might be interested in keeping this
information for say 6 months then deleting it if the space was not so

At 10:22 AM 12/17/97 -0800, you wrote:
>I'm archiving out the data to another table, identical to the calls table
before consolidation deletes it.
>I've designed a pretty hefty web interface to the Emerald Data so that
from there, we can look
>up past usage, beyond the last consolidation.
>On Monday, December 15, 1997 7:02 PM, William Salame
[] wrote:
>> Hi everyone.
>> We do call history conslidations once a month and we backup the
>> emerald database every day. Every time we consolidate, emerald
>> delete the previous calls logs. In the process no one can
>> view his previous login session.
>> I would like to know how others are dealing with the situations.
>> Do they restore from the backup into the emerald database
>> or to a new database.
>> Any ideas would be appreciated.
>> --
>> William Salame
>> Operations Manager
>> KNOWLEDGE by Design
>> ----------------------------------------------------------
>> Emerald Mailing List
> ----------------------------------------------------------
> Emerald Mailing List