October 18, 2021
Protecting data integrity with FairCom database backup
Resources and tips for maintaining access to data
Maintaining data integrity is an essential task in database operations. One way to protect your data is through backups.
Several options are available that allow database server administrators to back up FairCom DB and FairCom EDGE databases and c-treeRTG. These backup avenues include:
- Using FairCom’s hot backup method on specific files
- Using VSS backup integration on Windows
- Using ctQuiet/Quiesce
- Using a standard backup utility while the FairCom Server is shutdown
Best practices for backing up and recovering data
There are several best practices we suggest to ensure smooth backup and recovery operations.
First, we strongly recommend periodic backups so you can recover from database failures or roll back to a previous point in time if necessary.
Second, if you’re not using transactions, we recommend shutting down the server periodically (when possible) to allow a full backup.
In the world of backups, there is a key question that must be pondered in your backup: What good is a backup if you can’t restore a backup when needed? The best way to ensure you can access your data when you need to recover is to periodically test your backup and to check the integrity of the data.
While it is commonplace to have good backup strategies in place for databases, don’t forget about the rest of your IT ecosystem. In today’s climate of increasingly potent weather and bad actors trying to hold our data hostage, a sound backup strategy is more critical than ever.
Backup and Data Integrity Guide
You can read more about FairCom’s backup capabilities and best practices by visiting Backups and Data Integrity in our developer’s library. Topics covered include:
Copying FairCom Server Controlled Files
FairCom Database Restore Guide
FairCom Database Rollback Guide
FairCom Database Forward Roll Guide
Controls for Performance AND Safety of Non-Transaction Updates