Backing Up After You Change the Physical Schema

Home | Previous Page | Next Page Disk, Memory, and Process Management > Managing Disk Space > Specifying Names for Storage Spaces and Chunks >

Backing Up After You Change the Physical Schema

You must perform a level-0 backup of the root dbspace and the modified storage spaces to ensure that you can restore the data when you:

Add or drop mirroring
Drop a logical-log file
Change the size or location of the physical log
Change your storage-manager configuration
Add, move, or drop a dbspace, blobspace, or sbspace
Add, move, or drop a chunk to a dbspace, blobspace, or sbspace

Important:

When you add a new logical log, you no longer need to perform a level-0 backup of the root dbspace and modified dbspace to use the new logical log. However, you should perform the level-0 backup to prevent level-1 and level-2 backups from failing.

You must perform a level-0 backup of the modified storage spaces to ensure that you can restore the unlogged data before you switch to a logging table type:

When you convert a nonlogging database to a logging database
When you convert a RAW table to standard