Backing Up After Changing the Physical Schema

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Overview of the ON-Bar Backup and Restore System > Backing Up with ON-Bar > Backing Up Storage Spaces and Logical Logs >

Backing Up After Changing the Physical Schema

This section describes what to back up after you change the physical schema.

When to Back Up the Root Dbspace and Modified Storage Spaces

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

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.

Extended Parallel Server

It is recommended that you perform a complete level-0 backup after changing the physical configuration.

End of Extended Parallel Server

For example, if you add a new dbspace dbs1, you will 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.

Extended Parallel Server

For Extended Parallel Server, back up the root dbspace and the new or modified dbspace on the coserver where the change occurred.

End of Extended Parallel Server

Tip:

Although you no longer need to backup immediately after adding a log file, your next backup should be level-0 because the data structures have changed.

Warning:

If you create a new storage space with the same name as a deleted storage space, perform a level-0 backup twice:

Back up the root dbspace after you drop the storage space and before you create the new storage space with the same name.
After you create the new storage space, back up the root dbspace and the new storage space.

When to Back Up the Modified Storage Spaces Only

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

Convert a nonlogging database to a logging database.
Convert a raw, static, or operational table to standard. This backup ensures that the unlogged data is restorable before you switch to a logging table type.