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
- 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.
- Back up the root dbspace after you drop the storage space and before you create the storage space with the same name.
- 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
- 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.