Firebird table index deactivated after backup/restore

48 views Asked by At

After a backup/restore of my database in Firebird, I found out that the index of one of my tables got deactivated. It was activated before the backup. I did the backup/restore using FlameRobin with the default settings. I want to point out that the indices of the other tables where correctly activated, only the one of the biggest table got deactivated.

Could it be that the index is automatically deactivate during the backup/restore if the table is above a certain size? Is is possible to be sure that this issue doesn't happen again by using some options during the backup/restore?

0

There are 0 answers