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:
  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.