Consultor Eletrônico



Kbase 19348: Backup of multiple databases in a batch file on NT.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   22/12/1999
When trying to back up multiple databases from a batch file on NT, only the first database in the batch file will be backed up if you are running the probkup command, whether running online or offline.
In order to back up all the databases listed in the batch file, you must run the executables directly in the command line _dbutil for offline & _mprshut for online. Here are examples of both an offline & online backup of multiple databases in a batch file.

Offline
DLC\bin\_dbutil probkup c:\phil\phil c:\temp\backup_phil
DLC\bin\_dbutil probkup c:\phil\test c:\temp\backup_test
DLC\bin\_dbutil probkup c:\phil\test2 c:\temp\backup_test2

Online
DLC\bin\_mprshut c:\phil\phil -C backup online c:\temp\backup_phil
DLC\bin\_mprshut c:\phil\test -C backup online c:\temp\backup_test
DLC\bin\_mprshut c:\phil\test2 -C backup online c:\temp\backup_test2

There will be no errors in the log file because the first database will get backed up correctly. The probkup command for subsequent database will not execute, so no errors result, but the databases are not backed up. Without actually checking the disk for the backup files, it will seem as though all the databases were backed up, resulting in major problems if they need to be restored from disk.

Kbase # 19348