Application Servers
Log Files
The Logs folder for SHIPSTORE is normally stored on the root of a drive (i.e. E:\Logs). We recommend deleting all files in this folder older than 30 days.
Downloads files
Used for all files SHIPSTORE uses and creates, the "SHIPSTORE Extras" folder is typically located on the root of a drive (i.e. E:\SHIPSTORE Extras). We recommend clearing the following folders out periodically:
- \Downloads\Temp - Delete all files here. None of these are reused after they are first created
- \Downloads\Labels - Delete all files older than the archive period on your SHIPSTORE databases (usually 6 months)
- \Downloads\Manifests -Same as above
Cleanup script
Below is a download for a script file that will perform the above cleanup tasks on the app server. To use the script, download the file and adjust the variables (lines 3-14) to their proper values for your server. We normally recommend this script be ran monthy during off hours.
Database Servers
Archives
For higher volume environments, we generally recommend archiving old shipping data (any tables starting with the name "Shipment") to a separate database to keep SHIPSTORE running smoothly. This process is handled via the ArchiveHistory stored proceure on your SHIPSTOREv4_Prod database. We normally recommend running this stored procedure at least weekly as part of a maintenance plan.
Note: This archive process is normally set up on your database server when SS is first installed. If you do not see an "ArchiveHistory" stored procedure on your SHIPSTOREv4_Prod database, please contact support to have this created.
Backups
In accordance with industry standards, we recommend backing up your SHIPSTOREv4_Prod database daily in case of any database failures. The backup should be set as a Full, Copy-Only backup to take a snapshot of the SS DB as it is at the time of the backup.
Misc.
Every now and then, we recommend clearing out your SQL transaction logs on the SHIPSTORE* databases to save on disk space. We recommend doing this every 1 million shipments.