Does CATIE have the ability to backup the database? If so, do I need to purchase anything separate?

CATIE does have the ability to backup the database. For a limited time, when you purchase the Premium version you get the backup utility at no cost.