Subject | Re: [firebird-support] confiable backup? |
---|---|
Author | Daniel Rail |
Post date | 2003-06-24T09:31:50Z |
Hi,
At June 24, 2003, 05:43, Artur Anjos wrote:
1- You create a backup of your production database without knowing if
it is good or not.
2- Your production database gets corrupted sometime after, up to the
point that you can't use it.
3- You attempt to restore your backup, but your backup is not good and
doesn't want to restore.
End result: You have a corrupted database that is unusable and a
backup that can't be restored. So, what's next, pay IB Phoenix to see
if the corrupted database is fixable.
I think that a backup must be a sure thing. If there are problems
with the database when performing a backup, it should be indicated
at that moment. Not when performing the restore, once it's too late.
Not everybody will perform a backup, then immediately after do a
restore to a different place to see if the backup worked.
I know that some level of check is performed by the backup, but I
think that all checks should be performed by both the backup and
restore.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At June 24, 2003, 05:43, Artur Anjos wrote:
> The way to do a safe backup is:Take the following scenario:
> - Gbak to create the backup;
> - GBak to restore it on a different place;
1- You create a backup of your production database without knowing if
it is good or not.
2- Your production database gets corrupted sometime after, up to the
point that you can't use it.
3- You attempt to restore your backup, but your backup is not good and
doesn't want to restore.
End result: You have a corrupted database that is unusable and a
backup that can't be restored. So, what's next, pay IB Phoenix to see
if the corrupted database is fixable.
I think that a backup must be a sure thing. If there are problems
with the database when performing a backup, it should be indicated
at that moment. Not when performing the restore, once it's too late.
Not everybody will perform a backup, then immediately after do a
restore to a different place to see if the backup worked.
I know that some level of check is performed by the backup, but I
think that all checks should be performed by both the backup and
restore.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)