Kbase 18530: How to Automatically Backup a Big Multi-Volume Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to automatically backup your database even if the database is larger than the capacity of your backup media.
FACT(s) (Environment):
Progress 9.x
FIX:
You need to pass a list of filenames to PROBKUP, and the location of where these files should be created.
You also need enough available space on your hard disk or on the network, that is greater than the size of your database.
Create a single text file (vi input_file) and write to every line (except the first one) a filename with a full or relative path. (dependant on your working directory)
PROBKUP /path/dbname /path/bkup_file1 -vs <100> < /path/input_file
where dbname is your database name, bkup_file1 is the first backup volume to be created, <100> is the volume size ( units in database block size, not in Kb or Mb) and the input file is the file with the list of additional volumes.
During the prorest it may be necessary to add a blank line or the letter y to the first line of the input_file if you are overwriting an existing database as you may get the message:
Do you want to over write it? [y
]: Restore failed. (1618)
with no opportunity to answer the question when restoring.