Subject | Database/Backup consistency check |
---|---|
Author | Steffen Heil (Mailinglisten) |
Post date | 2016-07-04T18:52:13Z |
Hi
I have a database on a hard drive which is failing. The hard drive already has some bad sectors and we are about to replace it.
Now I have a backup of that database created with gbak that I could use. However I am not sure if the hard drive was still fine, when the backup was created.
On the other hand, I can right now access the database just fine and I could try to simply copy it.
As third option I could create a new backup to external media right now.
Now my questions:
- Is there any way to check a copied database file for corruption? If the file copy works without error (no file system I/O error) can I be sure or is there a command to be sure, if the file is completely intact?
- If I restore the backup and gbak does not report an error, can I be sure that everything is okay?
- If I create a new backup and gbak does not report an error, can I be sure that the new backup is okay?
There used to be a checksum in the page header, but IIRC that field was abandoned.
Then again I am still at 2.0.4...
Regards,
Steffen
[Non-text portions of this message have been removed]
I have a database on a hard drive which is failing. The hard drive already has some bad sectors and we are about to replace it.
Now I have a backup of that database created with gbak that I could use. However I am not sure if the hard drive was still fine, when the backup was created.
On the other hand, I can right now access the database just fine and I could try to simply copy it.
As third option I could create a new backup to external media right now.
Now my questions:
- Is there any way to check a copied database file for corruption? If the file copy works without error (no file system I/O error) can I be sure or is there a command to be sure, if the file is completely intact?
- If I restore the backup and gbak does not report an error, can I be sure that everything is okay?
- If I create a new backup and gbak does not report an error, can I be sure that the new backup is okay?
There used to be a checksum in the page header, but IIRC that field was abandoned.
Then again I am still at 2.0.4...
Regards,
Steffen
[Non-text portions of this message have been removed]