Subject | Re[3]: [firebird-support] Broken databases |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-11-15T18:44:22Z |
Hello, Dmitri!
PS> When I fix a DB with error I also restore the DB without activating the
PS> Indexes.
WHY? Firebird 2.1 and higher restores all indices it can, and show error on indices that it can't create
(by the PK or FK violation caused by broken records).
So, after restore (without -i) option you just need to check restore
output for errors, then check non-active indices in the DB, and try to
fix data and activate those non-active indices.
--
Dmitry Kuzmenko, www.ib-aid.com
PS> When I fix a DB with error I also restore the DB without activating the
PS> Indexes.
WHY? Firebird 2.1 and higher restores all indices it can, and show error on indices that it can't create
(by the PK or FK violation caused by broken records).
So, after restore (without -i) option you just need to check restore
output for errors, then check non-active indices in the DB, and try to
fix data and activate those non-active indices.
--
Dmitry Kuzmenko, www.ib-aid.com