Subject | consistency check for nbackup |
---|---|
Author | heilsteffen |
Post date | 2007-11-18T01:29:39Z |
Hi
I wrote a script to backup my databases using nbackup.
It is working fine, automatically manages 4 levels of backups for
quarters, months, weeks, days.
For every backup file it creates, it also checks wether nbackup is able
to restore the database and exits with exit code 0.
But I think this only assures, that the backup chain is okay, not that
the database itself is consistent.
Is there a safe way to check, that a just restored file is absolutely
consistent? I would like to include this in my script...
Regards,
Steffen
I wrote a script to backup my databases using nbackup.
It is working fine, automatically manages 4 levels of backups for
quarters, months, weeks, days.
For every backup file it creates, it also checks wether nbackup is able
to restore the database and exits with exit code 0.
But I think this only assures, that the backup chain is okay, not that
the database itself is consistent.
Is there a safe way to check, that a just restored file is absolutely
consistent? I would like to include this in my script...
Regards,
Steffen