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:

  1. 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
  2. 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.
  3. Store the copy in a secure location. Ensure that each stored copy includes both the archive and the journal.
  4. 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.