Subject | RE: [firebird-support] Re: problem with gbak |
---|---|
Author | Alan McDonald |
Post date | 2009-09-29T10:59:07Z |
> Thank you for your valuable suggestions.hmmm, wrong. a corrupt backup file can be created.
>
> 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.
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.
>wrong again - see above.
>
> 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).
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
>
>
>