Specifications

Call Detail Record Reports
C – 6 ShoreTel, Inc.
Archival services are configured and enabled in ShoreWare director, where you can
specify the number of days that records are maintained in the main database and in the
archive database. When archiving is enabled, archival services are performed daily. The
archival service copies records to the archive database that exceed the main database
age limit, then removes those records from the main database. Records that exceed the
age limit for the archive database are removed from the archive database. Age limits are
established separately for each database; valid limits range from one to 2000 days. The
default age limits for each database is 125 days.
Example: A sample implementation sets a 30 day limit on the main database and a
365 day limit on the archive database. In this case, the main database contains
records for calls handled during the past 30 days while the archive database
contains records for calls handled during the past 365 days.
The Backup utility can be used for record storage requirements that exceed 2000 days.
To create an archive database:
Step 1 Run MakeCDRArchive –d databasename, where databasename is the
name of the archive database to be created,
Step 2 Access the Reporting Options panel in ShoreWare Director (Reporting |
Options from the Menu panel) to configure ShoreWare to access the
archive database.
Database Backup Utility
The Backup utility creates a copy of a specified database, which can be restored at a
later time and different location. The Backup utility differs from the Archival utility as
follows:
• Archiving is configured once then performed daily. Backups are performed only
when a command is executed.
• Archival operations are configured from ShoreWare director. Backups are
performed from the command line.
• Archive databases can be accessed directly to generate reports. Backup databases
must be restored before performing search and report generation tasks.
Backup and Restore operations can be performed without shutting down the MySQL
service. Performing these operations during off peak hours reduces the execution time
and the impact on other system services.
The file located at "C:\Program Files\Shoreline Communications\Shoreware
Server\MySQL\MySQL Server 5.0\Examples\dump1.bat" is an example of a batch file
that backs up a MySQL CDR database under generic default conditions. This file can be
used as a template for creating a batch file that backs up the database under specific
conditions. The password is shorewaredba. Backing up a 1.5 GB database requires 200
seconds.
Refer to http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html for MySQL
backup tools, add-ons, and documentation.
Database Restore Utility
Restoring a database copies the records in the backup database file to the database
specified in the restore command. Records in the backup file that are duplicates of
records in the target database are listed in the log file and are not restored.