Subject RE: [firebird-support] Database Corrupt, can't backup and restore.
Author Alan McDonald
> Hi
>
> Sorry, I have no idea to help.
> But a very much related question to the others on this list:
>
> How can I check if a backup was really successful?

you restore it. no errors means the backup was good.
Alan

>
> I do scripted backups (quarterly, monthly, weekly, dayly, on some
> servers
> even hourly).
> I do this with multi-level backups via nbackup.
> For every backup done I also do a scripted restore, to see that this
> works.
>
> However I would like to run some consistency checks on that restored
> database to see if everything is really okay, as I think nbackup only
> copies
> data and does no real checks (except that the backup files belong
> together).
>
> Is there any DEFINITE way to tell if a database file is consistent
> (except
> for looking at all the data manually)?
> I am searching for some scriptable command...
>
> Best regards,
> Steffen
>

I would still run a backup of your nbackup restore, then a full restore from
that with gbak. It's all offline - it only costs cpu really.
Alan