On Fri, Jul 22, 2011 at 4:33 AM, bogdan <bogdan@...> wrote:

> **
>
>
> >> I can't recall if gbak returns an exit error code if something weird
> >> happens,
> >On Linux, it returns zero for all ok and 1 for something bad happened.
>
> >> but to check if a backup is valid, the only thing you can do is
> >> to restore the backup and see if this process goes through. This is
> > >something I do for critical databases/backups.
> >Always good advice. There is always a possibility that the backup
> >worked, but the file could still be corrupt. :-(
>
> We search backup and restore log for expected final text . If it is there
> then it is ok, otherwise not
> Regards
> Bogdan
>
>

For backups we grep for the expected success line. For restores we grep for
a failure line in the log files.

-steve

--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139

www.specializedbusinesssoftware.com
www.docunym.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936


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