sos online backup does not remember selection

Applying journal files restores all journaled updates from the time of the backup to the time of the failure. In the event of a failure that requires restoring from backup, you must also apply journal files to the restored copy of the database. The backup of a Caché database alone is not enough to provide a viable restore of production data. Copy link to this section Importance of Journals To protect enterprise databases from a disaster that could destroy the data center, regularly ship backup media to a secure off-site location. (Depending on your needs, you may have less stringent performance requirements of the storage device used for restoring backups, allowing for a less expensive storage solution.) In this way, the last-known good backup is always available for use in a disaster even if validation of the current backup fails. Therefore, the server on which you are validating the backup should ideally have twice the storage space required by production-space to store the last-known good backup as well as the backup you are currently validating. Once you restore the backup and establish that it is a viable source of recovery, it is best to preserve that restored copy until you establish the next good backup.

See the Importance of Journals section for more information. To perform these checks, you may need to restore journal files to restore transactional integrity. To further validate that the application is working correctly on the restored database, you can also perform application-level checks. If you discover an integrity error in the restored database, immediately run an integrity check on the production database to verify the integrity of the production system.

The converse, however, is not true: an integrity error detected on the restored copy of a database does not necessarily imply that there are integrity problems on the production database there could, for example, be errors in the backup media. The backup strategies described in this document preserve the physical structure of the database therefore, a clean integrity check of the restored copy implies that the integrity of the production database was sound at the time of the backup. If such an event occurs, you need only restore the updates in the journal files. Provides a warm copy of the backup, substantially reducing the time required to restore the backup in the event of a disaster. Validates the physical integrity of the databases in the backup, avoiding the problem of false reporting of integrity errors when running integrity checks on volatile databases affected by ongoing updates. Validates the recoverability of the backup media. The best practice - to restore every backup of the production environment to an alternate server and then validate the integrity of the restored databases (see Verifying Structural Integrity in the “Introduction to Data Integrity” chapter of this guide) - provides the following advantages: Regardless of the backup strategies you use, it is critical to restore backups on a regular basis to validate your procedures. Copy link to this section Backup Integrity and Recoverability

If you require more information to help you to develop a backup strategy tailored for your environment, or to review your current backup practices, contact the InterSystems Worldwide Response Center (WRC). It discusses the following topics:īackup strategies can differ depending upon your operating system, preferred backup utilities, disk configurations, and backup devices. In addition, the chapter contains details about the procedures used to perform these tasks using Caché utilities or other third-party utilities.

It discusses techniques for ensuring the integrity and recoverability of your backups, as well as suggested backup strategies. This chapter outlines the factors to consider when developing a solid plan for backing up your Caché system.

Configuring Caché Online Backup Settings.

Sos online backup does not remember selection