Subject | RE: [firebird-support] Database Corrupt, can't backup and restore. |
---|---|
Author | Alan McDonald |
Post date | 2009-08-02T12:29:46Z |
> Hiyou restore it. no errors means the backup was good.
>
> 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?
Alan
>I would still run a backup of your nbackup restore, then a full restore from
> 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
>
that with gbak. It's all offline - it only costs cpu really.
Alan