Customers hosting the Adonis solution onpremise are recommended to manage a backup solution. A backup is a copy of the data that can be used to restore the original after a data loss event. This article contains recommendations from Adonis.
We normally recommend to make a daily full backup of your database and incremental copy every 2 hours. You can use the SQL maintanance plan for making these backups. We strongly recommend to minimally backup your system onshore. If you do planning and wage calculation onboard we also recommend a copy of your vessel database.
Backups are best stored on another device with the following retention periods:
• Keep transaction log backups for 1 week or longer
• Keep the daily backups for 1-2 weeks or longer (daily backup)
• Keep one of the complete backups bi-weekly for 2 months (bi weekly backup)
• Keep one of the complete backups each month for 1 year (monthly backup)
• Keep one complete backup from the beginning/end of the (fiscal) year (yearly backup
We recommend you to have a backup of your server environment on top of the database backups. More background information like how to setup the backups can be found in the document below:
Instruction for scheduled SQL database backup.docx