Subject RE: [firebird-support] Re: problem with gbak
Author Alan McDonald
> Thank you for your valuable suggestions.
>
> We are going to make changes in our program as follows (the database
> was already disconnected from the application during back-up/restore) :
> -
>
> BACKUP
> (i) Take the backup through gbak as follows
> gbak -b -t -v -user "username" -pas "password" "Source_File_Path"
> "Destination_File_Path"
> (ii) If an output file is generated then the back up is successful.

hmmm, wrong. a corrupt backup file can be created.
You need to test the exit code of gbak. And you then need to restore to a
test restore filename and test the exit code again before you can be sure
that the backup is successful.

>
>
> RESTORE
> (i) Restore the backed up file through gbak as follows
> gbak -c -v -user "username" -pas "pay21fdb" "Backedup_File"
> "New_File"
> (ii) If output file is created successfully then replace the earlier DB
> with the file created in (ii).

wrong again - see above.
and never replace it. Always rename the original, name the restored to the
old filename and always keep the previosuly non backup copy of the DB in
case all these proccedures are faulty.

Alan
>
> Please let me know, apart from the 'v' switch, any other verification
> is recommended
>
> Thanking you
> Abhishek
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>