Kbase P46266: How to automate and validate offline backup on Windows for databases > 2GB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/16/2009 |
|
Status: Verified
GOAL:
How to automate and validate offline backup on Windows for databases > 2GB
GOAL:
How to backup databases > 2GB to multiple volumes
FACT(s) (Environment):
Windows
Products / Versions
OpenEdge Category: Database
FIX:
This script includes a multivolume capability to backup databases larger than 2 GB. It's necessary to first create a file called "bkvolume" that contains the path and names of the backup volumes.
The following script will:
- perform an off-line backup of the sports2000 database and
- if successful, perform a full verification of the backup.
"Test.out" will record checkpoints of pass/failure.
REM - - - - - - - START - - - - - ->>
@echo off
echo Test started. >> test.out
"%DLC%\bin\_dbutil" probkup .\sports2000 backup\bkvol1.bak -vs 262144 < bkvolume
if %errorlevel% == 0 goto BKUPOK
echo Backup failed. >> test.out
goto ENDPROG
:BKUPOK
echo Backup successful. >> test.out
"%DLC%\bin\_dbutil" prorest .\sports2000 backup\bkvol1.bak -vf < bkvolume
if %errorlevel% == 0 goto VERIFOK
echo Backup Verify failed. >> test.out
goto ENDPROG
:VERIFOK
echo Backup Verify successful. >> test.out
goto ENDPROG
:ENDPROG
REM <<- - - - - - END - - - - - - -
Example content of the bkvolume file:
backup\bkvol2.bak
backup\bkvol3.bak
backup\bkvol4.bak
backup\bkvol5.bak
backup\bkvol6.bak
backup\bkvol7.bak
backup\bkvol8.bak
backup\bkvol9.bak