General Steps for Backing Up Databases
To regularly create a copy of a database that is stored as a backup, NuoDB recommends the following steps:
- Define site-specific backup policies. For example, you might want guidelines for:
- Naming conventions for directories that will contain database copies
- How often to make copies of databases
- Any post-processing of database copy destination directories, for example, compressing them with an external tool or moving them to a remote location
- According to your backup policies, use offline backup or online backup to regularly obtain a copy of the current state of each database. A running database’s archive and journal provide the current state of that database.
- Store the copy in a secure location. Ensure that each stored copy includes both the archive and the journal.
- Add a snapshot storage manager (SSM) to your database. This lets you take advantage of online snapshot backup. An SSM saves a snapshot of the database for every committed transaction. When you want to restore data to a particular committed transaction you copy the snapshot of interest from the SSM.