Specifications
Reporting
17 – 8 ShoreTel, Inc.
Creating the Archive Database
The following procedure describes the process of creating a separate (optional) archive
database using the MakeCDRArchive.exe command line utility.
Step 1 To run this utility, verify that the following required files are located in
the same directory:
• MakeCDR.dll
• MakeCDR.sql
• MakeCDR_sp.sql
NOTE By default, the installer puts them at the following location on
the headquarters server:
C:\Program Files\Shoreline Communications \ ShoreWare Server
Step 2 Open the command prompt window in the directory shown above and
run the following command:
MakeCDRArchive -s localhost -d databasename
• databasename is the name of the archive database to be created. The
database name must be the same as the name created on the
Options page.
• If no name is defined, the default name of shorewarecdrarchive will
be created within the following directory:
C:\Shoreline Data \ Call Records2 \ Data
NOTE Records from main database will be archived to the archive
database when the services start up and every night at
approximately 12 a.m.