| Subject | Database was emptied no data in the tables - how this can happen ? |
|---|---|
| Author | infoneto |
| Post date | 2010-06-24T03:57:34Z |
We had several cases where information in database was deleted and we where left with all the tables empty. the database file size however seems correct. The deletion was not done by us.
We use firebird 2.0.3 on Windows XP
1. Is it possible that during backup - restore using gbak that we perform every night data will be lost ?
2. When restoring is interrupted the database is left in such empty state ? if so why restoring is not like a transaction that unless successful the database will be left unchanged.
3. During backup is it possible that the database will be changed (no access is performed during backup)
4. Can a corrupted backup be restored ?
Is there a way to restore the database to it original state ?
We use firebird 2.0.3 on Windows XP
1. Is it possible that during backup - restore using gbak that we perform every night data will be lost ?
2. When restoring is interrupted the database is left in such empty state ? if so why restoring is not like a transaction that unless successful the database will be left unchanged.
3. During backup is it possible that the database will be changed (no access is performed during backup)
4. Can a corrupted backup be restored ?
Is there a way to restore the database to it original state ?