Dependent upon the number of Mailroom installations, number of databases and users sharing a database service, databases can grow quickly in size and produce a high volume of transaction logs. In order to safeguard your data and ensure databases are optimal it is important that backups and other maintenance tasks are performed regularly.

Configuration

Enterprise environments should change the default location of databases and their backups and move them away from system drives e.g.

Edit c:\programdata\easypost\db\config.json as below changes the default database and backup folder location to e:\easypost_db\ and e:\easypost_backup\ respectively.

{
"DBRoot":"E:\\easypost_db\\",
"BackupFolder":"E:\\easypost_backup\\"
}

A restart of the EasyPost Mailroom database service is required to invoke any configuration changes.

Backup

Create a scheduled task to backup all of your EasyPost Mailroom databases.  Using dbtool.exe the database service can be instructed to backup all databases or individually. A backup will truncate all transactions log files and backup the database in full.

To individually backup the sales database to the backup folder as set in configuration run this command from an elevated command prompt.

dbtool -db sales -b

To backup all databases in one go use

dbtool -b -b_all

Clean

The EasyPost Mailroom is NOT a document management system and should not be used as such.  Although documents printed to the mailroom remain in the database indefinitely we recommend that you use the clean function to periodically cleanse the database of old historical data and any items deleted be users.

The following example removes items older than 180 days and all deleted items from the sales database.

dbtool -db sales -c +180

Anti Virus

To maintain database integrity the database service root folder should be excluded from real time protection and scheduled scans.