In speaking with Dale, I expanded the Emerald Db to 200 Mb and the Tempdb
to 160. (He suggested 30, but it failed on an earlier attempt). I deleted
the acctstatus type = 1 and then consolidated successfully. The two
processes took more than six hours of run time with all other services
Now, my Emerald db is still 163 Mb. There can't be that much junk in that
db for the number of subscribers that we have.... or could there be? How
can it reduce the size of the calls table after consolidating it?
It would be nice if Emerald would create some scheduled housekeeping tasks
to do recommended cleanup.
Duane Schaub, President |Terra World, Inc - Connecting The Planet
Terra World, Inc. |Southeast Kansas' Leading Provider
200 Arco Place, Suite 252 |Flat Fee - Never an hourly Charge
Independence, Kansas 67301 |Where Service is Top Priority!
Voice/Fax (316) 332-1616 |http://www.terranet.net
|email@example.com or firstname.lastname@example.org