Subject | Validate and backup ok, but restore with errors |
---|---|
Author | Francisco Ruiz |
Post date | 2006-02-19T11:52:30Z |
Hi
I have a FB 1.5.2 database. I use IBExpert for FB services.
If i try a validate database (validate full), no errors are found.
I make a backup (+ garbage collection) without errors.
But now, I try to restore it into a new database (commit after each
table). Last info lines are :
..........
IBE: Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
IBE: Restore completed. Current time: 19:39:02. Elapsed time: 00:00:16
and database is not well restored.
The restore stops when they reach one table; records are restored but
index are not restored (i don't see them in messages).
What can i do?
Do i need always to make a Restore after a backup to confirm database
is not corrupt?
Is there another way to detect those errors?
Saludos
Paco Ruiz
I have a FB 1.5.2 database. I use IBExpert for FB services.
If i try a validate database (validate full), no errors are found.
I make a backup (+ garbage collection) without errors.
But now, I try to restore it into a new database (commit after each
table). Last info lines are :
..........
IBE: Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
IBE: Restore completed. Current time: 19:39:02. Elapsed time: 00:00:16
and database is not well restored.
The restore stops when they reach one table; records are restored but
index are not restored (i don't see them in messages).
What can i do?
Do i need always to make a Restore after a backup to confirm database
is not corrupt?
Is there another way to detect those errors?
Saludos
Paco Ruiz