Ah yes - run gbak and check the return code for an error. I hadn't considered that. Thank you, Jacob.

Ideally, I was looking for a method that made use of the Services API (and therefore the Services API components). Perhaps someone knows of a way to acheive the same goal using that API? I'd prefer all this to be handled internal to the application. This is a database-desktop sort of app that will deploy using the embedded server and run exclusively off CD. While I could include gbak (or anything else, for that matter - I've tested this!) I would prefer not do that.

Has anyone successfully used the Services API to backup/restore and check the state of the backup/restored database? I assume this is the purpose of having TIBValidationService, but I don't see a way to get a result out of the thing that isn't a text message meant to be delivered to a user.

Thanks again :-)

Eddie

----- Original Message -----
From: Jacob Alberty
To: firebird-support@yahoogroups.com
Sent: Sunday, March 14, 2004 7:15 PM
Subject: Re: [firebird-support] Verify Backup


seems like the easiest way is to write a shell script that is run via
cron on the server, the typical method is to backup then restore to
another filename to verify that the backup worked then remove the
restored and then compress (using gzip or bzip2). sorry i currently do
not have a script to restore to another filename but i do have a script
to backup and then compress which i use for daily recurring backups.
Eddie Bush wrote:

> Hello Everyone,
>
> I have need to perform an invisible backup/restore to reduce user
> intervention for maintenance. The backup/restore is easy, but how can
> I actually, without human intervention, know that the operations
> completed successfully? I am currently using the Delphi Interbase
> Admin (Services API) components from IBX (v7.08), but I am not
> particularly beholden to these components if another component set
> would be better and is equally inexpensive.
>
> Is anyone aware of a way to do this? I have thought about watching
> the output generated, but I'm not sure what I'd be watching for in the
> event of a backup/restore failure. I was hoping for an error code I
> could check, but I've yet to find it ...
>
> Thanks so much!
>
> Eddie Bush


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.620 / Virus Database: 399 - Release Date: 3/11/2004

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