Re: [Emerald] Database Maintanence records

david leigh ( (no email) )
Sat, 27 Mar 1999 18:49:10 +0800

Thanks for the below response Dale. All much clearer now :-)

David Leigh

>Emerald 2.5 comes with a script named insttask.sql that contains five
>schduled tasks:
>1) Weekly Check Database
>2) Nightly Database Dump
>3) Nightly Log Cleanup
>4) Calls Update for Servers
>5) Calls Update for Accounts
>The first three are vital for maintaing your database, and just run
>stored procedures that are also included in the instproc.sql script.
>the CheckDatabase proc only does a "DBCC CheckDB(Emerald", I would
>replacing the proc with the checkdb.sql script that is much more
>The only other thing you should need to do is run the consolidation from
>batch and peridically use the Admin to trim your calls table.
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list, including removal,
>please see

For more information about this list, including removal,
please see