Recommended Server Maintenance



Application Servers

First install 7zip at this URL : 7zipDownload, you can download either of the below options in the list on the website and save to the Default option when running the setup.

Download .exe 64-bit x64 7-Zip for 64-bit Windows x64 (Intel 64 or AMD64)
Download .exe 32-bit x86 7-Zip for 32-bit Windows


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/Temp files

Used for all files SHIPSTORE uses and creates, the "SHIPSTORE Extras" folder is 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 30 days)
  • \Downloads\Manifests
    • Delete all files older than 6 months

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, rename it as a ".bat" file, and adjust the variables (lines 2-8) to their proper values for your server.




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.