Subject | RE: [firebird-support] Best way to test a backup is OK programmatically |
---|---|
Author | Alan McDonald |
Post date | 2007-12-13T22:58:45Z |
> hello there. i am programmatically backing up a firebirdRestore is the only way to PROVE no corruption.
> database before performing an application/metadata update.
>
> what is the best way for me to test that the backup is OK and
> not corrupted etc.? i assumed it was to do a test restore.
> however somebody said this might not be necessary, and would
> take a long time for large databases. however, it's important
> i know that i have got a restorable backup before meddling
> with the metadata.
>
> any advice much appreciated. thanks.
Yes - it will take along time to restore on large databases.
I always test metadata changes on me dev database. There is very little
(read no) chance that such a test will pass on the dev DB and cause
corruption on the production DB.
Alan