Plan a backup system for a production database server

To plan for adequate backup protection for your data, analyze your database server configuration and activity and the types of backup media available at your installation.

Also, consider your budget for storage media, disks, computers and controllers, and the size of your network.

Actions after which to perform a level-0 back up

You must perform a level-0 backup of, at minimum, the root dbspace and the modified storage spaces after you perform any of the following actions:
  • Add or drop mirroring.
  • Move, drop, or resize a logical-log file.
  • Change the size or location of the physical log.
  • Change your storage-manager configuration.
  • Add, move, or drop a dbspace.
  • Add, move, or drop a chunk to any type of storage space.
  • Add, move, or drop a blobspace or sbspace.

For example, if you add a new dbspace dbs1, you see a warning in the message log that asks you to perform a level-0 backup of the root dbspace and the new dbspace. If you attempt an incremental backup of the root dbspace or the new dbspace instead, ON-Bar automatically performs a level-0 backup of the new dbspace.

Tip: Although you no longer need to back up immediately after adding a log file, your next backup should be level-0 because the data structures have changed.
If you create a storage space with the same name as a deleted storage space, perform a level-0 backup twice:
  1. Back up the root dbspace after you drop the storage space and before you create the storage space with the same name.
  2. After you create the storage space, back up the root dbspace and the new storage space.

Actions before which to perform a level-0 back up

You must perform a level-0 backup of the modified storage spaces before you perform any of the following actions:
  • Convert a nonlogging database to a logging database.
  • Before you alter a RAW table to type STANDARD. This backup ensures that the unlogged data is restorable before you switch to a logging table type.