Backup by Unloading
Unloading a database is a time-consuming method for backing up and recovering your database, because all of your database’s files must be unloaded and reloaded. For this reason, we recommend that you use checkpointing instead.
Unloading a database, however, can be useful as a backup tool because it enables you to:
• Generate copy scripts, which can be used to recreate your database.
• Recover particular tables by editing the copy.in scripts. For a description of the copy.in scripts, see the chapter “Loading and Unloading Databases.”
To accomplish this task using a system command, use the unloaddb command. For more information, see the Command Reference Guide.
For the detailed steps for generating these scripts using VDBA, see the Procedures section of online help. See the Creating Unload and Reload Scripts topic.