Subject [firebird-support] Multifile Backup and Multifile Restore help.
Author Martin Dew
Hi,



I have the following batch file which takes a mulitfile backup and
attempts to create a multifile restored gdb, however when I run it I get
the following error; Can anyone point out where my syntax is wrong ? I
have read up loads of pages on the web and just cannot see what I have
got wrong.



ERROR

gbak: gbak version WI-V1.5.2.4731 Firebird 1.5

gbak: opened file C:\owl\owl\cs_data\data\Test\kobackup.bk1

gbak: opened file C:\owl\owl\cs_data\data\Test\kobackup.bk2

gbak: opened file C:\owl\owl\cs_data\data\Test\kobackup.bk3

gbak: ERROR: size specification either missing or incorrect for file
C:\owl\owl\cs_data\data\Test\ko.gdb

gbak: Exiting before completion due to errors





THE BATCH FILE ( I have broken down the lines to wrap so its easier to
read for the newsgroups purpose, when run the command is all on one
line)



echo on

c:

cd \

cd "c:\progra~1\Firebird\Firebi~1\bin"

echo commencing restore .........

gbak -c -z -v -user SYSDBA -password masterkey -y
C:\owl\owl\cs_data\data\Test\restore.txt

C:\owl\owl\cs_data\data\Test\kobackup.bk1

C:\owl\owl\cs_data\data\Test\kobackup.bk2

C:\owl\owl\cs_data\data\Test\kobackup.bk3

C:\owl\owl\cs_data\data\Test\ko.gdb 1M

C:\owl\owl\cs_data\data\Test\ko.gd2 1M

C:\owl\owl\cs_data\data\Test\ko.gd3 1M

C:\owl\owl\cs_data\data\Test\ko.gd4

pause

echo Restore Complete..

echo -----------------

cd \



Basically what I want is 2 batch files, the first which takes a
multifile live gdb and backs it up to a multifile backup. Then I need to
offer the user a batch file to take this multifile backup and restore it
again to the multifile live gdb.



Any help you can offer is much appreciated, perhaps someone out there
has some much better batch files than I have written (I expect so, mine
are only basic).



Regards

Martin



[Non-text portions of this message have been removed]