There are numerous backup methods generally; complete or partial, hot or cold.
A simple method is a cold complete backup:
- Stop Noodle
- Stop the database
- Copy the database folder and the Noodle folder
- Start the database
- Start Noodle
- Send the folder copies to a different physical location
Backup option selection:
- Hot complete backups: Allow a snapshot of your database without stopping anything.
- Hot partial backups: Can be used to backup only recent changes, allow for point in time recovery, and reduce server load. Can also be used to keep a warm backup server in case of disaster. At any time it will be a usable exact copy of your production database.
- Cold partial backups: Can decrease the time of a cold complete backup.
- Cold complete backups: Are the simple option.
Production environments should select a backup strategy to maximize flexibility while reducing server load and storage requirements.
For details on backup options please read your VM and database documentation:
Also see the Windows PostgreSQL example.